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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
turning every 5th line red (1999)
Webstar 4.2 Stops Serving (2000)
ShippingCosts (1998)
Hiding HTML and page breaks (1997)
Targeting [redirect] to a frame? (1998)
Math function in Formula.db (1997)
Include vs. lookup? (1998)
[WebDNA] Stuck with installing Webdna 8.5 (2017)
BadSuffix with 2.1b3 cgi (1997)
WebCat2 Append problem (B14Macacgi) (1997)
TCPConnect and SSL servers (2001)
iis 4.0 (1997)
b18 problem on NT 4.0 (1997)
Protect Tag and Groups (1998)
MySQL (2003)
emailer settings and control questions (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Version f1 status (1997)
[Summary] re: Emailer setup (1997)