Re: How can I record purchases to a database?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17814
interpreted = N
texte = .00>>>>As you can see, I am getting everything but the [cart] number. I'm>>assuming that this is because the cart number is not part of the line>>items in the cart. (Makes sense.)>>>>Now my question is - How do I get the cart number to be included in the>>record that is written to the database?>>It looks like you have to loop through the lineitems to get the informationyou want from the cart, but that you have to append the cart value outsideof a lineitems loop in order for it to stick.Not being familiar with the context, can youa) build the record by looping through the lineitems as a separate step andwriting them to a variable before you appendor b) do a second append to add the cart number?If nothing else (it seems kind of convoluted), you append the record withjust the lineitems, find the record and then replace it with the cartnumber included.fwiwChris GurscheEC&T Electronic Colour & Type CorpChris GurscheCopyDot
Associated Messages, from the most recent to the oldest:
.00>>>>As you can see, I am getting everything but the
[cart] number. I'm>>assuming that this is because the cart number is not part of the line>>items in the cart. (Makes sense.)>>>>Now my question is - How do I get the cart number to be included in the>>record that is written to the database?>>It looks like you have to loop through the lineitems to get the informationyou want from the cart, but that you have to append the cart value outsideof a lineitems loop in order for it to stick.Not being familiar with the context, can youa) build the record by looping through the lineitems as a separate step andwriting them to a variable before you appendor b) do a second append to add the cart number?If nothing else (it seems kind of convoluted), you append the record withjust the lineitems, find the record and then replace it with the cartnumber included.fwiwChris GurscheEC&T Electronic Colour & Type CorpChris GurscheCopyDot
Chris Gursche
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCommerce: Folder organization ? (1997)
Secure Sever and showcart errors (1997)
Bug? (1997)
[WebDNA] Broken Links on Webdna.us Website (2011)
[WebDNA] Some code inside a large loops fail ... but why? (2010)
Re:PCS Customer submissions ? (1997)
Multiple prices (1997)
Fwd: FW: Purchase Command error (1997)
Strange ThisURL under Linux (2000)
show me your store ! (2003)
WCS Newbie question (1997)
Pithy questions on webcommerce & siteedit (1997)
Shipping Calc - Help please (1998)
Re:2nd WebCatalog2 Feature Request (1996)
headers (2000)
Summing fields (1997)
Upgrade to WebCat2 from Commerce Lite (1997)
Pithy questions on webcommerce & siteedit (1997)
b12 cannot limit records returned and more. (1997)
Download URL & access on the fly ? (1997)