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:
Browser Problem?!? Still getting Error message using POST! (1997)
Appending current [date] to a database (1997)
If Empty ? (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Error handling for accountNum (1997)
What abobut variables named max ??? (2000)
[WebDNA] Another strange WebDNA problem (2013)
no global [username] or [password] displayed ... (1997)
Listserver problem (1997)
Re:Version 2.0 and 1.6 simultaneous (1997)
[WebDNA] Receive JSON POST (2019)
Alpha List for Catagory (1998)
japanese characters (1997)
TIP OF THE DAY (2004)
Can't find templaes (1997)
PCS Customer submissions ? (1997)
Storebuilder/Webmerchant and Manual CC Processing (2001)
newbies to web, spaces in email address (1998)
Re:What file? (1997)