Price Not Appearing

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28338
interpreted = N
texte = All the values from my database appear properly on the Search.tpl, Reults.tpl, ShoppingCart.tpl, and Invoice.tpl pages, but the price value won't display on ShoppingCart.tpl or Invoice.tpl. All the price values appear as $0.00 on these pages. Everything else, even the quantity value, appear as they should.Oddly, the price value is shown properly in WebMerchant's LineItems.db.I swear that I've checked this WebDNA code closely against the TeaRoom example, but can't find anything that would prevent this from working. I'd appreciate any help.Thanks, Glenn--------------------------------------------------------------------------- On the Results.tpl page---(usual html stuff) [search db=POL.db&eqCategorydata=[url][Category][/url]&asNamesort=1&asSKUsort=2&max= 10&startat=[url][startat][/url]] [foundItems] [/foundItems]
Item #NameSizePrice 
[SKU][Name]
[CommonName]
[Description]		[Size]$[format .2f][price][/format]DetailsAdd to your Shopping Cart
---------------------------------------------------------------------------On the ShoppingCart.tpl page-- (usual html stuff) [lineItems] [/lineItems]
Line #Item #NameShipping SizeQtyPrice Each 
[lineIndex][SKU][Name][Size]$[format 6.2f][price][/format]Remove it from your Cart
------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Price Not Appearing SOLUTION (Glenn Busbin 2000)
  2. Re[2]: Price Not Appearing [LONG] (jpeacock@univpress.com 2000)
  3. Re: Price Not Appearing (Kenneth Grome 2000)
  4. Re: Price Not Appearing (Glenn Busbin 2000)
  5. Re: Price Not Appearing (Glenn Busbin 2000)
  6. Re: Price Not Appearing (Kenneth Grome 2000)
  7. Re: Price Not Appearing (Glenn Busbin 2000)
  8. Re: Price Not Appearing (Glu Rgla 2000)
  9. Re: Price Not Appearing (Peter Ostry 2000)
  10. Re[2]: Price Not Appearing (jpeacock@univpress.com 2000)
  11. Re: Price Not Appearing (elive talklists 2000)
  12. Re: Price Not Appearing (Kenneth Grome 2000)
  13. Re: Price Not Appearing (Kenneth Grome 2000)
  14. Re: Price Not Appearing (Glenn Busbin 2000)
  15. Re: Price Not Appearing (Kenneth Grome 2000)
  16. Re: Price Not Appearing (Kenneth Grome 2000)
  17. Re: Price Not Appearing (Glenn Busbin 2000)
  18. Re: Price Not Appearing (Glenn Busbin 2000)
  19. Re: Price Not Appearing (Mike Davis 2000)
  20. Re: Price Not Appearing (John Butler 2000)
  21. Re: Price Not Appearing (John Butler 2000)
  22. Re: Price Not Appearing (Glenn Busbin 2000)
  23. Re: Price Not Appearing (Kenneth Grome 2000)
  24. Re: Price Not Appearing (Glenn Busbin 2000)
  25. Re: Price Not Appearing (Kenneth Grome 2000)
  26. Re: Price Not Appearing (Kenneth Grome 2000)
  27. Re: Price Not Appearing (Glenn Busbin 2000)
  28. Re: Price Not Appearing (Single Guy 2000)
  29. Price Not Appearing (Glenn Busbin 2000)
All the values from my database appear properly on the Search.tpl, Reults.tpl, ShoppingCart.tpl, and Invoice.tpl pages, but the price value won't display on ShoppingCart.tpl or Invoice.tpl. All the price values appear as $0.00 on these pages. Everything else, even the quantity value, appear as they should.Oddly, the price value is shown properly in WebMerchant's LineItems.db.I swear that I've checked this WebDNA code closely against the TeaRoom example, but can't find anything that would prevent this from working. I'd appreciate any help.Thanks, Glenn--------------------------------------------------------------------------- On the Results.tpl page---(usual html stuff) [search db=POL.db&eqCategorydata=[url][Category][/url]&asNamesort=1&asSKUsort=2&max= 10&startat=[url][startat][/url]] [founditems] [/foundItems]
Item #NameSizePrice 
[SKU][Name]
[CommonName]
[Description]		[Size]$[format .2f][price][/format][cart]&sku=[url][sku][/url]>Details[cart]&db=POL.db&sku=[url][sku][/url ]>Add to your Shopping Cart
---------------------------------------------------------------------------On the ShoppingCart.tpl page-- (usual html stuff) [lineitems] [/lineItems]
Line #Item #NameShipping SizeQtyPrice Each 
[lineIndex][SKU][Name][Size]$[format 6.2f][price][/format]Remove it from your Cart
------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Glenn Busbin

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:

Odd search results, or odd programmer, not sure which... (2002) Grant, please help me ... (1997) PCS Frames (1997) trouble updating records in database (1998) Limiting user access to .tmpl files (1997) WebCat2 several catalogs? (1997) error (2000) Emailer setup (1997) Associative lookup style? (1997) Online reference (1997) taxTotal, grandTotal (1997) PCS Emailer's role ? (1997) [WebDNA] Conditional search (2009) [OT] Brain Switching (2004) Error Messages Returned to User (1997) AppleScript question (1997) All questions are welcome on this list (1997) Forms Search Questions (1997) Locking up with WebCatalog... (1997) [click][/click] (1999)