Re: if else problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54638
interpreted = N
texte = Parentheses are optional if you only have one comparison, but required =20=if you have multiple:[if ("[currency]"=3D"EUR") | ("[currency]"=3D"USD")]...- brianOn Dec 4, 2003, at 8:16 AM, Erol Guneri wrote:> I normally wrap my If statements in parenthesis, so it looks like:>> [if ("[currency]"=3D"EUR")]>> I don't know if it is right, but it works for me.>> Erol>>>> ----- Original Message -----> From: "Alan White"
> To: "WebDNA Talk" > Sent: Thursday, December 04, 2003 4:09 PM> Subject: if else problem>>>> 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> 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> 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:
Parentheses are optional if you only have one comparison, but required =20=if you have multiple:[if ("[currency]"=3D"EUR") | ("[currency]"=3D"USD")]...- brianOn Dec 4, 2003, at 8:16 AM, Erol Guneri wrote:> I normally wrap my If statements in parenthesis, so it looks like:>> [if ("[currency]"=3D"EUR")]>> I don't know if it is right, but it works for me.>> Erol>>>> ----- Original Message -----> From: "Alan White" > To: "WebDNA Talk" > Sent: Thursday, December 04, 2003 4:09 PM> Subject: if else problem>>>> 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> 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> 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:
Merging databases (1997)
Resume Catalog ? (1997)
Help (1999)
Template Security error (1997)
Odd Cart Behavior (1997)
WC TableGrinder (1997)
PCS Frames (1997)
Database Security (1998)
[format] minus figures (2003)
the dreaded unitShipCost (2003)
my price won't move (1997)
db merge problem (2002)
[SEARCH] Context for SKU prices not working... (1998)
WebStar Secure on other machine (1997)
form data submission gets truncated (1997)
taxrate - off by 1 cent (1997)
Problems with Search Engine (2000)
Showing unopened cart (1997)
Sub Categories (2000)
[WebDNA] "Safe Write for Database" setting.... (2016)