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 information you want from the cart, but that you have to append the cart value outside of 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 and writing 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 with just the lineitems, find the record and then replace it with the cart number included.fwiw Chris Gursche EC&T Electronic Colour & Type CorpChris Gursche CopyDot Associated Messages, from the most recent to the oldest:

    
  1. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  2. Re: How can I record purchases to a database? (PCS Technical Support 1998)
  3. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  4. Re: How can I record purchases to a database? (PCS Technical Support 1998)
  5. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  6. Re: How can I record purchases to a database? (Chris Gursche 1998)
  7. Re: How can I record purchases to a database? (Sandra L. Pitner 1998)
  8. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  9. re: How can I record purchases to a database? (Kenneth Grome 1998)
  10. re: How can I record purchases to a database? (Jerry Nielsen 1998)
  11. How can I record purchases to a database? (Jerry Nielsen 1998)
.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 information you want from the cart, but that you have to append the cart value outside of 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 and writing 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 with just the lineitems, find the record and then replace it with the cart number included.fwiw Chris Gursche EC&T Electronic Colour & Type CorpChris Gursche CopyDot 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:

case number with spaces. (2000) Quit revisited (1997) Quick poll (2003) re: [addlineitem] working almost (1997) [WebDNA] Sort by Row (2017) Displaying raw values (long) (1998) WebCatalog for Postcards ? (1997) Math inside [showif] (1998) Ping... (2006) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Re:2nd WebCatalog2 Feature Request (1996) Emailer setup (1997) Adding up line items. (2000) [WebDNA] Installing WebDNA 7 on OSX Mavericks Server - Instructions (2014) [search] in formulas.db (1997) [WebDNA] remove preceding zero (2016) Maillist content (was WebDNA for Dummies) (2004) A few questions. . . (1997) Line items in table cells (1997) Buying sans cart (1997)