Re: if else problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54636
interpreted = N
texte = When comparing text strings with an [if], you need to quote the values; =20=otherwise it attempts a numerical comparison:[if "[currency]"=3D"USD"]etc...- brianOn Dec 4, 2003, at 8:09 AM, Alan White wrote:> Hi folks>> I am having a little bit of difficulty with an [if] [else] statement. ==20> I am> trying to check the variable [currency] and then display the relevant =20=> result> based upon it.>> Here is the code which is performed within a [founditems] context:->> [text]USDcost=3D[math][PRICE]*[lookup> db=3Dadmin/=20> mycurrency.db&value=3DUSD&lookinfield=3Dcurrency&returnfield=3DexchangeR=a> te][/math][/text]> [text]JPYcost=3D[math][PRICE]*[lookup> db=3Dadmin/=20> mycurrency.db&value=3DJPY&lookinfield=3Dcurrency&returnfield=3DexchangeR=a> te][/math][/text]> [text]EURcost=3D[math][PRICE]*[lookup> db=3Dadmin/=20> mycurrency.db&value=3DEUR&lookinfield=3Dcurrency&returnfield=3DexchangeR=a> te][/math][/text]>> [if [currency]=3DUSD]> [then]> [text]priceDisplay=3D$[format 10.2f][USDcost][/format][/text]> [/then]> [else]> [if [currency]=3DEUR]> [then]> [text]priceDisplay=3D=80[format =10.2f][EURcost][/format][/text]> [/then]> [else]> [if [currency]=3DJPY]> [then]> [text]priceDisplay=3D=A5[format =20> 10.2f][JPYcost][/format][/text]> [/then]> [else]> [text]priceDisplay=3D=A3[format =10.2f][PRICE][/format][/text]> [/else]> [/if]> [/else]> [/if]> [/else]> [/if]>> -----------------> The idea is that I then display the cost as follows:->> [priceDisplay]>> The [PRICE] gets displayed even when the various other currencies are =20=> passed> into the page...>> Hope someone can help....>> Alan>-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com =20= ---------------------------------------------------------------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:
When comparing text strings with an [if], you need to quote the values; =20=otherwise it attempts a numerical comparison:[if "[currency]"=3D"USD"]etc...- brianOn Dec 4, 2003, at 8:09 AM, Alan White wrote:> Hi folks>> I am having a little bit of difficulty with an [if] [else] statement. ==20> I am> trying to check the variable [currency] and then display the relevant =20=> result> based upon it.>> Here is the code which is performed within a [founditems] context:->> [text]USDcost=3D[math][PRICE]*[lookup> db=3Dadmin/=20> mycurrency.db&value=3DUSD&lookinfield=3Dcurrency&returnfield=3DexchangeR=a> te][/math][/text]> [text]JPYcost=3D[math][PRICE]*[lookup> db=3Dadmin/=20> mycurrency.db&value=3DJPY&lookinfield=3Dcurrency&returnfield=3DexchangeR=a> te][/math][/text]> [text]EURcost=3D[math][PRICE]*[lookup> db=3Dadmin/=20> mycurrency.db&value=3DEUR&lookinfield=3Dcurrency&returnfield=3DexchangeR=a> te][/math][/text]>> [if [currency]=3DUSD]> [then]> [text]priceDisplay=3D$[format 10.2f][USDcost][/format][/text]> [/then]> [else]> [if [currency]=3DEUR]> [then]> [text]priceDisplay=3D=80[format =10.2f][EURcost][/format][/text]> [/then]> [else]> [if [currency]=3DJPY]> [then]> [text]priceDisplay=3D=A5[format =20> 10.2f][JPYcost][/format][/text]> [/then]> [else]> [text]priceDisplay=3D=A3[format =10.2f][PRICE][/format][/text]> [/else]> [/if]> [/else]> [/if]> [/else]> [/if]>> -----------------> The idea is that I then display the cost as follows:->> [priceDisplay]>> The [PRICE] gets displayed even when the various other currencies are =20=> passed> into the page...>> Hope someone can help....>> Alan>-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com =20= ---------------------------------------------------------------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/
Brian Fries
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:
[WriteFile] problems (1997)
Claris HomePage messes up the code (1997)
email database file (2005)
Search design (1997)
Re(6): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
Auto conversion of URLs? (1998)
Country & Ship-to address & other fields ? (1997)
Converting SQL Microtime to Date and Time (2003)
WebCatalog on Linux (2000)
Duplicate Cart Problem in Netscape (2000)
Searching multiple fields from one form field (1997)
Using Applescript to process WebCatalog functions (1998)
[WebDNA] Sorry WebDNA server not running - September 2019 Edition (2019)
PC Cookie Problem? (2003)
Size of a folder? (2003)
emailer (1997)
Webdna sends your serial number on Internet (2003)
Sorting by date (1997)
About the + sign (2002)
Error:Too many nested [xxx] contexts (1997)