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:
UPDATE PROBLEM (1997)
Harvesting invalid email addresses from bounced emails??? (2000)
[TaxableTotal] - not working with AOL and IE (1997)
ShippingCosts (1998)
[WriteFile] problems (1997)
[SHOWIF AND/OR] (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Help formatting search results w/ table (1997)
[body_include] (2001)
OFF-TOPIC: Check www.godaddy.com for me ... (2003)
nested showif? (1998)
[sendmail] questions... (1997)
Explorer 3.0/ Access Denied! (1997)
blank page from template (1997)
NY taxRates.db? (1997)
Sort Order on a page search (1997)
why is this line in GeneralStore? (1998)
WebTEN vs webSTAR (1998)
Filling in fields conditionally (1998)
Rendering out a page-test results (1997)