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:

WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Newbie needs advice to learn to use WebDNA (2003) RequiredFields template (1997) Moving files from one server to another... (2001) webcat serving up 2+ versions of the same db? (2000) simple answer? [hideif] (1997) Universal root for WC errors? (1997) japanese characters (1997) Jimmy (1998) Multiple Pulldowns (1997) Extended [ConvertChars] (1997) Webcatalog quitting (1997) OT: Collaborative Browsing (2000) Quitting WebMerchant ? (1997) Sorry just a test ... (2004) WebCatalog can't find database (1997) Search for value or blank? (2004) Identical [Replace] contexts, different results in different directories? (2000) updating with ProductEditor (1998) Non WebDNA forms and timed popups... (2002)