Re: Counting LineItems

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 32434
interpreted = N
texte = try that lookup like this-[lookup db=discount.db&value=[header40]&lookInField=quant&returnField=discamnt¬Found=nope]You want to look in the quant field, not the [quant] field ... right?I have made that mistake many times ;-)HTH -Johnchas wrote:> Duly acknowledged! Thanks John.. > > --- You wrote: > It may seem like alot, but try to read all the docs. > --- end of quote --- > > So... I think I've got everything right > addlineitem displays, but still am having a difficulty getting the price lookup to fire..... > > Here is the addlineitem and where it lives on the template. > Am I not able to use the value of [header40] in the lookup? > > I have two db references... 1 for the regular product.db (required by addlineitem) and the discount.db lookup.... > > ....... > Your Order Number is #[cart] > > header40=[header40] > > [addlineitem cart=[cart]&sku=2168&db=products.db&]password=thepassword&textD=[URL]Fresh Discount[/URL]&quantity=1&price=[lookup db=discount.db&value=[header40]&lookInField=[quant]&returnField=discamnt¬Found=nope][/addlineitem] > >
> > > > > > > > > > > > > [lineItems] > > > > > > > > > > [/lineItems] > > --------the discount.db is---- > > discount.db is > > quantdiscamnt > 10 > 20 > 3-38.01 > 4-50.68 > 5-63.35 > 6-105 > 7-122.5 > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Item #QtyProduct #Product NamePriceExtension
[lineIndex][quantity][sku][textA] [textB] [textC] [textD]$[price]$[format .2f][math][quantity]*[price][/math][/format]
    
  1. Re: Counting LineItems (chas@valley.net (chas) 2000)
  2. Re: Counting LineItems (John Butler 2000)
  3. Re: Counting LineItems (chas@valley.net (chas) 2000)
  4. Re: Counting LineItems (John Butler 2000)
  5. Re: Counting LineItems (chas@valley.net (chas) 2000)
  6. Re: Counting LineItems (John Butler 2000)
  7. Re: Counting LineItems (Kenneth Grome 2000)
  8. Re: Counting LineItems (chas@valley.net (chas) 2000)
  9. Re: Counting LineItems (John Peacock 2000)
  10. Re: Counting LineItems (chas@valley.net (chas) 2000)
  11. Re: Counting LineItems (chas@valley.net (chas) 2000)
  12. Re: Counting LineItems (kalin@el.net 2000)
  13. Re: Counting LineItems (kalin@el.net 2000)
  14. Re: Counting LineItems (Kenneth Grome 2000)
  15. Re: Counting LineItems (kalin@el.net 2000)
  16. Re: Counting LineItems (kalin@el.net 2000)
  17. Re: Counting LineItems (John Butler 2000)
  18. Re: Counting LineItems (John Peacock 2000)
  19. Re: Counting LineItems (chas@valley.net (chas) 2000)
  20. Re: Counting LineItems (John Butler 2000)
  21. Re: Counting LineItems (John Butler 2000)
  22. Re: Counting LineItems (John Butler 2000)
  23. Re: Counting LineItems (John Peacock 2000)
  24. Re: Counting LineItems (chas@valley.net (chas) 2000)
  25. Re: Counting LineItems (John Butler 2000)
  26. Re: Counting LineItems (chas@valley.net (chas) 2000)
  27. Re: Counting LineItems (Brian Boegershausen 2000)
  28. Counting LineItems (chas@valley.net (chas) 2000)
try that lookup like this-[lookup db=discount.db&value=[header40]&lookInField=quant&returnField=discamnt¬Found=nope]You want to look in the quant field, not the [quant] field ... right?I have made that mistake many times ;-)HTH -Johnchas wrote:> Duly acknowledged! Thanks John.. > > --- You wrote: > It may seem like alot, but try to read all the docs. > --- end of quote --- > > So... I think I've got everything right > addlineitem displays, but still am having a difficulty getting the price lookup to fire..... > > Here is the addlineitem and where it lives on the template. > Am I not able to use the value of [header40] in the lookup? > > I have two db references... 1 for the regular product.db (required by addlineitem) and the discount.db lookup.... > > ....... > Your Order Number is #[cart] > > header40=[header40] > > [addlineitem cart=[cart]&sku=2168&db=products.db&]password=thepassword&textD=[url]Fresh Discount[/URL]&quantity=1&price=[lookup db=discount.db&value=[header40]&lookInField=[quant]&returnField=discamnt¬Found=nope][/addlineitem] > > > [cart]> > > > > > > > > > > > > [lineitems] > > > > > > > > > > [/lineItems] > > --------the discount.db is---- > > discount.db is > > quantdiscamnt > 10 > 20 > 3-38.01 > 4-50.68 > 5-63.35 > 6-105 > 7-122.5 > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ John Butler

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:

POST (1997) Re:PCS Customer submissions ? (1997) Re:redirect from the errorsMessages.db entry (1997) PCS Customer submissions ? (1997) Stumpted Again (1997) [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (2009) Searching with a form (2000) [searchString] (1997) How do I enter a carriage return for my StartAfter valuein (2002) WebCat/Typhoon Status under Windows (1998) Editing Users.db (1997) Dual processors? (2000) Math Problem - Format? (1997) Setting up shop (1997) [WebDNA] A new popuated field to a DB with 700.000 records (2009) Authorize.net? (2003) Re:no [search] with NT (1997) Path of Events (1999) Cross-platform file names? (2000) Server Freeze (1998)
Item #QtyProduct #Product NamePriceExtension
[lineIndex][quantity][sku][textA] [textB] [textC] [textD]$[price]$[format .2f][math][quantity]*[price][/math][/format]