Re: Frustration with formulas.db
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25483
interpreted = N
texte = Brian and Kenneth,Thanks for the pointers. The Shipcost modification appears to work. Can you explain the [hideif 0=[math]0[lineitems] syntax, something I've seen in several places. I assume the whole calculation is hidden if the result is 0 ([hideif 0=0]) but what does 0[lineitems] do? Is this interpreted as 01 for the first lineitem, 02 for the second, etc.?I'm still have problems with the sales tax. Maybe I don't understand the point of [interpret]. In the example I posted below, am I supposed to put [interpret][taxRate][/interpret] in my .tpl file? This doesn't seem to work; the tax always comes back as 0.00. However, if I embed the [lookup] directly in my .tpl page, it returns the proper percentage.Thanks for your valuable advice,Kevin Lippert On 12/14/99 2:06 AM, you wrote:>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
Associated Messages, from the most recent to the oldest:
Brian and Kenneth,Thanks for the pointers. The Shipcost modification appears to work. Can you explain the [hideif 0=[math]0[lineitems] syntax, something I've seen in several places. I assume the whole calculation is hidden if the result is 0 ([hideif 0=0]) but what does 0[lineitems] do? Is this interpreted as 01 for the first lineitem, 02 for the second, etc.?I'm still have problems with the sales tax. Maybe I don't understand the point of [interpret]. In the example I posted below, am I supposed to put [interpret][taxRate][/interpret] in my .tpl file? This doesn't seem to work; the tax always comes back as 0.00. However, if I embed the [lookup] directly in my .tpl page, it returns the proper percentage.Thanks for your valuable advice,Kevin Lippert On 12/14/99 2:06 AM, you wrote:>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
Kevin Lippert
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:
MacWorld NY (2000)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Webmerch tags? (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
Linux -> OS X (2002)
serial number (1998)
PIXO support (1997)
Summary search -- speed (1997)
writing orders to a db (1997)
[Applescript] (2000)
OT- AS/400 and Macs (2003)
Platform Switch (1997)
Email/Sendmail in WEBDNA has stopped... (2004)
FWD: Autoproxy Bug with WebCatalog and FireSite (1997)
Protect (1997)
Setting up the server (1997)
triggers have stopped once again (2002)
[carts] and databases (1997)
Ok here is a question? (1997)
WebCatalog/Mac 2.1b2 - PIXO (1997)