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:

    
  1. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  2. Re: Frustration with formulas.db (Kevin Lippert 1999)
  3. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  4. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  5. Re: Frustration with formulas.db (Kenneth Grome 1999)
  6. Frustration with formulas.db (Kevin Lippert 1999)
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:

RE: protect tag on NT (1997) Help name our technology! (1997) Another search question please... (1998) WebCatalog dying in WebTen Revisited (1998) Invoice Data Fields (1999) WebDNA and SQL (2003) More DateMath problems (1997) RE: 2nd WebCatalog2 Feature Request (1996) Max Record length restated as maybe bug (1997) [BoldWords] WebCat.acgib15Mac (1997) Re:Emailer and encryption (1997) Share Bulletin Board? (1998) Append..... doesn't (2000) WebCat2 - [format thousands] (1997) Emailer [cart] file names (1997) Limit on nested [ShowIf]'s? (1997) YACBQ.....(Yet another checkbox question) (2000) [WebDNA] php -> WebDNA: Can I do this with [tcpconnect]? (2013) emailer and bad addresses (1997) Email Formatting (1998)