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:
Format of Required fields error message (1997)
[carts] and databases (1997)
uploads (2000)
Date Sorting (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Multiple SSL Keys (1998)
Xserve Recommendations (2003)
Finding max value for a field (1997)
Document Contains No Data! (1997)
NTbeta18 corrupted? (1997)
SiteGaurd file Cache vs webcatalog cache (1997)
Execute Applescript (1997)
bug in [SendMail] (1997)
Smart caching problems with 2.1b3? (1997)
Plugin or CGI or both (1997)
Re:no template caching (1997)
2.0 Info (1997)
Many $WebCat.exe processes (1998)
Snake Bites (1997)
WebCatalog/WebMerchant 2.1 (1998)