Re: Frustration with formulas.db
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25460
interpreted = N
texte = For the tax problem, make sure you have a field in the database named taxable with each product set to true or the tax will not work. As for your shipping, you need to fix your formula a bit. You formula: Shiptype [math]2.00+([lineitems](1*[quantity])[/lineitems])[/math] should be called shipcost, and is not going to calculate correctly because you need to make it show everyline item qualtity. Try: Shipcost [hideif 0=[math]0[lineitems]+[quantity][/lineitems][/math]][math]2.00+(2.00*(0[linei tems]+[quantity][/lineitems]))[/math][/hideif] This will add all the quantities up for you and also zero out the shipping cost if they check out the shoppingcart page before any items have been added.Brian Boegershausen WebCatalog Programmer www.orderbywire.com ----- Original Message ----- From: Kevin Lippert
To: WebCatalog Talk Sent: Tuesday, December 14, 1999 12:24 AM Subject: Frustration with formulas.db > I'd like the taxRate to lookup on [State] if [ShipToState] is blank (so > people don't have to enter a ShipToState seperately). My first thought is > that this is easiest to do in formulas.db, something like: > > taxRate [interpret][lookup db=TaxRates.db&lookInField=State&value=[showif > [ShipToState]>][ShipToState][/showif][showif > [ShipToState]=][State][/showif]&returnField=taxRate¬Found=0.00][/inter > pret] > > which seems to return the proper tax rate based on the value in [State], > but the builtin [taxTotal] value always returns 0.00. Does this come > from someplace else than [taxRate]*[taxableTotal]? > > A second, maybe related question, concerns ShipCosts.db. We want to > charge $4 for the first item, and $2 for each item thereafter. Again, I > thought it easiest to use this formula in ShipCosts.db: > > Shiptype [math]2.00+([lineitems](1*[quantity])[/lineitems])[/math] > > the logic here being $2.00 plus ($2 * the number of items), but this > doesn't seem to work, either (even wrapped in [interpret]) > > Can I not use formulas like [math] and [showif] in lookups like these? > > Thanks in advance, > > Kevin Lippert > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
For the tax problem, make sure you have a field in the database named taxable with each product set to true or the tax will not work. As for your shipping, you need to fix your formula a bit. You formula: Shiptype [math]2.00+([lineitems](1*[quantity])[/lineitems])[/math] should be called shipcost, and is not going to calculate correctly because you need to make it show everyline item qualtity. Try: Shipcost [hideif 0=[math]0[lineitems]+[quantity][/lineitems][/math]][math]2.00+(2.00*(0[linei tems]+[quantity][/lineitems]))[/math][/hideif] This will add all the quantities up for you and also zero out the shipping cost if they check out the shoppingcart page before any items have been added.Brian Boegershausen WebCatalog Programmer www.orderbywire.com ----- Original Message ----- From: Kevin Lippert To: WebCatalog Talk Sent: Tuesday, December 14, 1999 12:24 AM Subject: Frustration with formulas.db > I'd like the taxRate to lookup on [State] if [ShipToState] is blank (so > people don't have to enter a ShipToState seperately). My first thought is > that this is easiest to do in formulas.db, something like: > > taxRate [interpret][lookup db=TaxRates.db&lookInField=State&value=[showif > [ShipToState]>][ShipToState][/showif][showif > [ShipToState]=][State][/showif]&returnField=taxRate¬Found=0.00][/inter > pret] > > which seems to return the proper tax rate based on the value in [State], > but the builtin [taxTotal] value always returns 0.00. Does this come > from someplace else than [taxRate]*[taxableTotal]? > > A second, maybe related question, concerns ShipCosts.db. We want to > charge $4 for the first item, and $2 for each item thereafter. Again, I > thought it easiest to use this formula in ShipCosts.db: > > Shiptype [math]2.00+([lineitems](1*[quantity])[/lineitems])[/math] > > the logic here being $2.00 plus ($2 * the number of items), but this > doesn't seem to work, either (even wrapped in [interpret]) > > Can I not use formulas like [math] and [showif] in lookups like these? > > Thanks in advance, > > Kevin Lippert > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Brian Boegershausen
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:
[SearchString] problem with [search] context (1997)
shipCost not working v2.1b4 (1997)
filtering extra characters from credit card numbers (2001)
[shownext max=?] armed (1997)
Where is eudora plugin? (1998)
Browser frames and URLs in the Location field (2004)
OK, here goes... (1997)
[WebDNA] Send URL Get without waiting for response (2014)
Websited Development (1999)
Has this happened to you? (was:Emailer Chokes on bad address) (1997)
Banners (1997)
Need relative path explanation (1997)
Share cost of training videos! (1998)
Bug Report, maybe (1997)
Bug or syntax error on my part? (1997)
Multiple prices (1997)
Upgrading to 10.1.5 (2002)
Standalone Testing (1998)
Sku numbers (1997)
[Sum] function? (1997)