Re: Cart questions

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13887
interpreted = N
texte = The following is still a mystery.> >3 Subtotal always displays 0.00 how is that calculated. I can open the > >formulas.db and they look OK. Any Ideas? > > Does GrandTotal show up?Yes, this always displays whatever the shipping fee is.> > >4. When I try to set the price with the addlineitem it tells me I dont > >have permission to do that. I am having trouble with the price lookup in > >the formulas.db, it does not return the price because webcat doesnt seem > >to have the correct sku when the formula executes. > > How are you looking up price? You can't just put [price] in, because the formula is not in the context of a lineitem at that point. Have you tried [lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]?I have [lookup db=Products.db&lookInField=SKU&value=[SKU]&returnField=price]. If I put this directly in the shopping cart template it displays the price correctly but the price field is always 0.00 in the cart file. Thanks for all help. This list is great.:) Paul Winchester Seattle Support Group Associated Messages, from the most recent to the oldest:

    
  1. Re: More Shopping Cart Questions/Problems (Brian Boegershausen 2000)
  2. More Shopping Cart Questions/Problems (Brady J. Horenstein 2000)
  3. RE: Shopping Cart Questions (PCS Technical Support 1998)
  4. RE: Shopping Cart Questions (Pat McCormick 1998)
  5. RE: Shopping Cart Questions (josh 1998)
  6. Re: Shopping Cart Questions (Rob Marquardt 1998)
  7. Shopping Cart Questions (josh 1998)
  8. RE: Shopping Cart Questions (Pat McCormick 1998)
  9. Price lookup problem - was Re: Cart questions (Paul Winchester 1997)
  10. Re: Cart questions (Grant Hulbert 1997)
  11. Re: Cart questions (Grant Hulbert 1997)
  12. Re: Cart questions (Paul Winchester 1997)
  13. Re: Cart questions (Paul Winchester 1997)
  14. Re: Cart questions (Grant Hulbert 1997)
  15. Cart questions (Paul Winchester 1997)
  16. three cart questions (Thomas Wedderburn-Bisshop 1997)
The following is still a mystery.> >3 Subtotal always displays 0.00 how is that calculated. I can open the > >formulas.db and they look OK. Any Ideas? > > Does GrandTotal show up?Yes, this always displays whatever the shipping fee is.> > >4. When I try to set the price with the addlineitem it tells me I dont > >have permission to do that. I am having trouble with the price lookup in > >the formulas.db, it does not return the price because webcat doesnt seem > >to have the correct sku when the formula executes. > > How are you looking up price? You can't just put [price] in, because the formula is not in the context of a lineitem at that point. Have you tried [lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]?I have [lookup db=Products.db&lookInField=SKU&value=[SKU]&returnField=price]. If I put this directly in the shopping cart template it displays the price correctly but the price field is always 0.00 in the cart file. Thanks for all help. This list is great.:) Paul Winchester Seattle Support Group Paul Winchester

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:

[OT] Ratings comparison? (2003) PIXO support (1997) Changes to the List (1997) [WebDNA] Poll: Discussion Forum (2009) Navigator Parsing (1997) Help! WebCat2 bug (1997) Multiple adding (1997) Ampersand Character (&) (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Cookie Issue - No domain (2004) Emailer (1997) Size limit for tmpl editor ? (1997) Line items in table cells (1997) Formatting dates stored in db (2003) Dynamic Pop up menu? (1997) New public beta available (1997) Sendmail (1997) help needed: Non-english characters in WebCatalog (1997) WriteFile Formatting (2000) Sendmail Excel Attachment (2006)