Re: Price and Formula.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45467
interpreted = N
texte = make sure you add all the other things that the formula database needs.mine looks like this:NAME FORMULA UNITSHIPCOST [text]line_ship_amount=0.00[/text][search db=/db/.....[line_ship_amount] SHIPCOST [showif [Lookup ......][/orderfile][/showif] PRICE [text].....YES]TBA[/hideif] TAXRATE 12.5 TAXABLE Talso take your lookups out of the database and make sure they work by themselves.----- Original Message ----- From: Glenn Busbin To: WebCatalog Talk Sent: Wednesday, November 20, 2002 8:45 AM Subject: Price and Formula.db > I have a Formulas.db like this: > > Name Formula > Price [Math][lookup db=dbs/Products.db&lookinfield=SKU&value=[SKU]&returnfield=Price]+[lookup db=dbs/Options.db&lookinfield=Options&value=[Option]&returnfield=ExtraCost][ /Math] > > There is a after the formula and the db is tabbed. > > The Formulas.db and ShoppingCart.tpl template are in the same folder. > > On the ShoppingCart template, all prices show up as $0.00. The ErrorLog shows no errors. > > I use the same formula to display prices on another template, so I know it's finding the variables and correctly adding them together. > > There's a thread about this in the archives, but the solution was never posted. > > What to do? > > Glenn > > ------------------------------------------------------------- > 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:

    
  1. Re: [SMSI]Re: Price and Formula.db (Donovan 2002)
  2. Re: [SMSI]Re: Price and Formula.db (Scott Anderson 2002)
  3. [SMSI]Re: Price and Formula.db (Donovan 2002)
  4. Re: Price and Formula.db (John Peacock 2002)
  5. Re: Price and Formula.db (Donovan 2002)
  6. Re: Price and Formula.db (Glenn Busbin 2002)
  7. Re: Price and Formula.db (Donovan Brooke 2002)
  8. Re: Price and Formula.db (Gary Krockover 2002)
  9. Re: Price and Formula.db (Gary Krockover 2002)
  10. Re: Price and Formula.db (Gary Krockover 2002)
  11. Re: Price and Formula.db (Glenn Busbin 2002)
  12. Re: Price and Formula.db (Donovan Brooke 2002)
  13. Re: Price and Formula.db (Stuart Tremain 2002)
  14. Re: Price and Formula.db (Arturo Vargas 2002)
  15. Re: Price and Formula.db (Andrew Simpson 2002)
  16. Re: Price and Formula.db (Glenn Busbin 2002)
  17. Re: Price and Formula.db (Gary Krockover 2002)
  18. Re: Price and Formula.db (Donovan 2002)
  19. Re: Price and Formula.db (Glenn Busbin 2002)
  20. Re: Price and Formula.db (Donovan 2002)
  21. Re: Price and Formula.db (Andrew Simpson 2002)
  22. Re: Price and Formula.db (Glenn Busbin 2002)
  23. Re: Price and Formula.db (Donovan 2002)
  24. Re: Price and Formula.db (Andrew Simpson 2002)
  25. Re: Price and Formula.db (Andrew Simpson 2002)
  26. Re: Price and Formula.db (Glenn Busbin 2002)
  27. Re: Price and Formula.db (Andrew Simpson 2002)
  28. Price and Formula.db (Glenn Busbin 2002)
make sure you add all the other things that the formula database needs.mine looks like this:NAME FORMULA UNITSHIPCOST [text]line_ship_amount=0.00[/text][search db=/db/.....[line_ship_amount] SHIPCOST [showif [Lookup ......][/orderfile][/showif] PRICE [text].....YES]TBA[/hideif] TAXRATE 12.5 TAXABLE Talso take your lookups out of the database and make sure they work by themselves.----- Original Message ----- From: Glenn Busbin To: WebCatalog Talk Sent: Wednesday, November 20, 2002 8:45 AM Subject: Price and Formula.db > I have a formulas.db like this: > > Name Formula > Price [math][lookup db=dbs/Products.db&lookinfield=SKU&value=[SKU]&returnfield=Price]+[lookup db=dbs/Options.db&lookinfield=Options&value=[Option]&returnfield=ExtraCost][ /Math] > > There is a after the formula and the db is tabbed. > > The formulas.db and ShoppingCart.tpl template are in the same folder. > > On the ShoppingCart template, all prices show up as $0.00. The ErrorLog shows no errors. > > I use the same formula to display prices on another template, so I know it's finding the variables and correctly adding them together. > > There's a thread about this in the archives, but the solution was never posted. > > What to do? > > Glenn > > ------------------------------------------------------------- > 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/ Andrew Simpson

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:

Help! WebCat2 bug (1997) I don't think my install worked (2003) taxTotal (1997) docs for WebCatalog2 (1997) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) [taxRate] [TaxTotal] ? (1997) math problems (2000) More on the email templates (1997) [WebDNA] Which EC2 instance? (2008) WC2.0 Memory Requirements (1997) change the number format (1997) [ot] windowsXP - check this site... (2004) [Announce]: Web server security and password protection (1997) .. more on sliding discounts... (1997) Old Topic - [OT] - server speeds. (2002) New WebDNA Forum Solution (in development) (2003) Max Record length restated as maybe bug (1997) WebCatalog can't find database (1997) [applescript] (1999) Part Html part WebDNA (1997)