Re: Still can't get this taxrate to work...
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25516
interpreted = N
texte = Try this instead:taxRate [lookup db=taxrates.db&lookInField=State&value=[showif [ShipToState]!][ShipToState][/showif][hideif[ShipToState]!][State][/hideif]&returnField=taxRate¬Found=0.00]Be sure that you flush the tables after you make this change; WebCat will notnotice you have changed the formula's database.You should also be very sure that only the states you have in your table can belooked up, i.e. have a
for the states. HTHJohn Peacock____________________Reply Separator____________________Subject: Still can't get this taxrate to work... Author: (WebCatalog Talk)Date: 12/15/99 6:26 PMThe goal is to lookup the tax rate based on [State] if [ShipToState] is blank. So I've put this line in taxrates.db:taxRate [lookup db=taxrates.db&lookInField=State&value=[showif [ShipToState]>][ShipToState][/showif][showif [ShipToState]=][State][/showif]&returnField=taxRate¬Found=0.00]This returns 0.00.I've tried wrapping [taxRate] with an [interpret] context in my .tpl page, but to no avail.Seems like it should work; what am I doing wrong?TIA,Kevin Lippert-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
Re: Still can't get this taxrate to work... (jpeacock@univpress.com 1999)
Try this instead:taxRate [lookup db=taxrates.db&lookInField=State&value=[showif [ShipToState]!][ShipToState][/showif][hideif[ShipToState]!][State][/hideif]&returnField=taxRate¬Found=0.00]Be sure that you flush the tables after you make this change; WebCat will notnotice you have changed the formula's database.You should also be very sure that only the states you have in your table can belooked up, i.e. have a for the states. HTHJohn Peacock____________________Reply Separator____________________Subject: Still can't get this taxrate to work... Author: (WebCatalog Talk)Date: 12/15/99 6:26 PMThe goal is to lookup the tax rate based on [State] if [ShipToState] is blank. So I've put this line in taxrates.db:taxRate [lookup db=taxrates.db&lookInField=State&value=[showif [ShipToState]>][ShipToState][/showif][showif [ShipToState]=][State][/showif]&returnField=taxRate¬Found=0.00]This returns 0.00.I've tried wrapping [taxRate] with an [interpret] context in my .tpl page, but to no avail.Seems like it should work; what am I doing wrong?TIA,Kevin Lippert-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
jpeacock@univpress.com
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:
Summing fields (1997)
X etc.... (1999)
Getting total number of items ordered (1997)
Web Catalog 2 demo (1997)
WCS Newbie question (1997)
OT: Web Cams (2003)
[writefile] (1997)
duplicating cart items (1998)
WebCatalog/WebMerchant Manuals Available (1998)
emailer (1997)
Here we go again... was: DDEConnect not working (2006)
VBScript and WebDNA (2003)
Commitdatabase tag (1998)
New servers and new inline cache (1997)
suffix mapping, use of cache, etc. (1997)
Test - sorry (2003)
&fieldsdir=ra truely random?? (2000)
Any way to retrieve information from clipboard? (1999)
Country & Ship-to address & other fields ? (1997)
carriage returns in data (1997)