Re: Forumulas.db & Variables
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45847
interpreted = N
texte = price [lookup db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price]taxRate [showif [url][state][/url]=WA]8.25[/showif]0shipCost [showif [ShipVia]=1]5[/showif][showif [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100taxable TJesse, I think you are going to find that your system here will give your false values. for example: if your shipvia is 1, I think you will end up with a ship cost of $1100.00.Do this instead. [if [shipvia]=1][then]5[/then][else][if [ShipVia]=2][then]10[/then][else][if [ShipVia]=3][then]15[/then][else]100[/else][/if][/else][/if][/else][/if]Donovan(your taxrate code will work since if it is WA the number will end up 8.250) Jesse Williams-Proudman wrote:> On 12/1/02 11:19 AM, WJ Starck
wrote: > > > Show us what your formula in formulas.db looks like... > > Well, this was just for testing: > > price [lookup > db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price > ] > > taxRate [showif [url][state][/url]=WA]8.25[/showif]0 > > shipCost [showif [ShipVia]=1]5[/showif][showif > [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100 > > taxable T > > I also tried wrapping taxrate and shipcost in [orderfile] and that didn't > work. > > -- > ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
price [lookup db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price]taxRate [showif [url][state][/url]=WA]8.25[/showif]0shipCost [showif [ShipVia]=1]5[/showif][showif [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100taxable TJesse, I think you are going to find that your system here will give your false values. for example: if your shipvia is 1, I think you will end up with a ship cost of $1100.00.Do this instead. [if [shipvia]=1][then]5[/then][else][if [ShipVia]=2][then]10[/then][else][if [ShipVia]=3][then]15[/then][else]100[/else][/if][/else][/if][/else][/if]Donovan(your taxrate code will work since if it is WA the number will end up 8.250) Jesse Williams-Proudman wrote:> On 12/1/02 11:19 AM, WJ Starck wrote: > > > Show us what your formula in formulas.db looks like... > > Well, this was just for testing: > > price [lookup > db=data/products.db&lookinfield=sku&value=[url][sku][/url]&returnfield=price > ] > > taxRate [showif [url][state][/url]=WA]8.25[/showif]0 > > shipCost [showif [ShipVia]=1]5[/showif][showif > [ShipVia]=2]10[/showif][showif [ShipVia]=3]15[/showif]100 > > taxable T > > I also tried wrapping taxrate and shipcost in [orderfile] and that didn't > work. > > -- > ------------------------------------------------------------- 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://webdna.smithmicro.com/
Donovan Brooke
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:
[WebDNA] HTTP Streaming -- impossible? (2010)
international time (1997)
Random tags HELP!!!! (1999)
Possible Bug in 2.0b15.acgi (1997)
WebCatalog 2.0 b 15 mac (1997)
I forgot (1998)
Weird Cookie Problem Part 2 (2007)
Formulas.db + Users.db (1997)
(1997)
webten vs. webstar (1998)
Finding unused SKU's in a database (2002)
Re2: frames & carts (1997)
[WebDNA] WebDNA hosting (2012)
PCS Frames (1997)
[OT] Security Certs (2000)
ShowNext - HELP! (2000)
Gremlins, huh? (2000)
Server crash (1997)
Enhancement Request for WebCatalog-NT (1996)
Nesting format tags (1997)