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 FORMULAUNITSHIPCOST [text]line_ship_amount=0.00[/text][searchdb=/db/.....[line_ship_amount]SHIPCOST [showif [Lookup ......][/orderfile][/showif]PRICE [text].....YES]TBA[/hideif]TAXRATE 12.5TAXABLE Talso take your lookups out of the database and make sure they work bythemselves.----- Original Message -----From: Glenn Busbin
To: WebCatalog Talk Sent: Wednesday, November 20, 2002 8:45 AMSubject: Price and Formula.db> I have a Formulas.db like this:>> Name Formula> Price [Math][lookupdb=dbs/Products.db&lookinfield=SKU&value=[SKU]&returnfield=Price]+[lookupdb=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 ErrorLogshows no errors.>> I use the same formula to display prices on another template, so I knowit's finding the variables and correctly adding them together.>> There's a thread about this in the archives, but the solution was neverposted.>> 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:
make sure you add all the other things that the formula database needs.mine looks like this:NAME FORMULAUNITSHIPCOST [text]line_ship_amount=0.00[/text][searchdb=/db/.....[line_ship_amount]SHIPCOST [showif [Lookup ......][/orderfile][/showif]PRICE [text].....YES]TBA[/hideif]TAXRATE 12.5TAXABLE Talso take your lookups out of the database and make sure they work bythemselves.----- Original Message -----From: Glenn Busbin To: WebCatalog Talk Sent: Wednesday, November 20, 2002 8:45 AMSubject: Price and Formula.db> I have a formulas.db like this:>> Name Formula> Price [math][lookupdb=dbs/Products.db&lookinfield=SKU&value=[SKU]&returnfield=Price]+[lookupdb=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 ErrorLogshows no errors.>> I use the same formula to display prices on another template, so I knowit's finding the variables and correctly adding them together.>> There's a thread about this in the archives, but the solution was neverposted.>> 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)