Re: Forumulas.db & Variables
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45847
interpreted = N
texte = price [lookupdb=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 falsevalues.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 [lookupdb=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 falsevalues.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 Solutions ... (1997)
shipping costs (2000)
Not really WebCat (1997)
WebCatalog Q & A pages (1997)
Closing databaes (2002)
WebMerchant Config problems (2000)
Getting total number of items ordered (1997)
accessing Webcat from another server (2000)
acrobat -> wc (1998)
Graphing Modules (2004)
WebCatalog [FoundItems] Problem - LONG - (1997)
[WebDNA] Crashing Database (2011)
Error: Can't open order file. Ignoring [OrderFile] context (2000)
triggers (2000)
Duplicate Carts (2006)
Personal Web Server combined with Webcatalog 2.1 (1998)
bug in [SendMail] (1997)
Shipcost lookup? (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
POS (2000)