Re: Forumulas.db & Variables
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45849
interpreted = N
texte = If this isn't working only one of two possibilities exist:1) Formulas.db is in the wrong path 2) ShipVia isn't being filled in for some reason, or isn't being filled in with what you expect. Could be permissions if you're on OSXI'd put this on the page your looking to have the formula work:[orderfile cart=[cart]] Shipvia=[shipvia] [/orderfile]What does [shipvia] return there?-Will On Sunday, December 1, 2002, at 09:16 PM, Donovan Brooke wrote:> 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 > > Jesse, 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/ > ------------------------------------------------------------- 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:
If this isn't working only one of two possibilities exist:1) formulas.db is in the wrong path 2) ShipVia isn't being filled in for some reason, or isn't being filled in with what you expect. Could be permissions if you're on OSXI'd put this on the page your looking to have the formula work:[orderfile cart=[cart]] Shipvia=[shipvia] [/orderfile]What does [shipvia] return there?-Will On Sunday, December 1, 2002, at 09:16 PM, Donovan Brooke wrote:> 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 > > Jesse, 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/ > ------------------------------------------------------------- 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/
WJ Starck
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:
Math Problem - Format? (1997)
Windows 95/NT tip of the month (1998)
an easy one... (2000)
Protecting Files (2005)
Reversing [ipaddress] normalization (1998)
New Site Announcement (1998)
BGcolor (1997)
ExclusiveLock (2000)
Re(6): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
Hiding HTML and breaking the page (1997)
Erotic Sites (1997)
forms and variables (1998)
Shell and telnet (2002)
webcat2b12 CGI -- Date comparisons (1997)
[sendmail] bug? (2000)
[OT] Snow Ctd. :) (2004)
webcat in the subject line - SMSI (2002)
grep - regular expression help (2007)
when is date system date or order date? (1997)
Location of Browser Info.txt file (1997)