Re: if else problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54637
interpreted = N
texte = Tried both of those suggestions and it doesn't seem to like it :(Still getting getting [PRICE] which is supposed to be the last else if ther=eare no currencies as a variable.Any other takers?ThanksAlan=20on 12/4/03 4:16 PM, Brian Fries at webdna@brainscansoftware.com wrote:> When comparing text strings with an [if], you need to quote the values;> otherwise it attempts a numerical comparison:>=20> [if "[currency]"=3D"USD"]> etc...>=20> - brian>=20> On Dec 4, 2003, at 8:09 AM, Alan White wrote:>=20>> Hi folks>>=20>> I am having a little bit of difficulty with an [if] [else] statement.>> I am>> trying to check the variable [currency] and then display the relevant>> result>> based upon it.>>=20>> Here is the code which is performed within a [founditems] context:->>=20>> [text]USDcost=3D[math][PRICE]*[lookup>> db=3Dadmin/=20>> mycurrency.db&value=3DUSD&lookinfield=3Dcurrency&returnfield=3DexchangeRa>> te][/math][/text]>> [text]JPYcost=3D[math][PRICE]*[lookup>> db=3Dadmin/=20>> mycurrency.db&value=3DJPY&lookinfield=3Dcurrency&returnfield=3DexchangeRa>> te][/math][/text]>> [text]EURcost=3D[math][PRICE]*[lookup>> db=3Dadmin/=20>> mycurrency.db&value=3DEUR&lookinfield=3Dcurrency&returnfield=3DexchangeRa>> te][/math][/text]>>=20>> [if [currency]=3DUSD]>> [then]>> [text]priceDisplay=3D$[format 10.2f][USDcost][/format][/text]>> [/then]>> [else]>> [if [currency]=3DEUR]>> [then]>> [text]priceDisplay=3D=E2=82=AC[format 10.2f][EURcost][/format][/text]>> [/then]>> [else]>> [if [currency]=3DJPY]>> [then]>> [text]priceDisplay=3D=C2=A5[format>> 10.2f][JPYcost][/format][/text]>> [/then]>> [else]>> [text]priceDisplay=3D=C2=A3[format 10.2f][PRICE][/format][/text]>> [/else]>> [/if]>> [/else]>> [/if]>> [/else]>> [/if]>>=20>> ----------------->> The idea is that I then display the cost as follows:->>=20>> [priceDisplay]>>=20>> The [PRICE] gets displayed even when the various other currencies are>> passed>> into the page...>>=20>> Hope someone can help....>>=20>> Alan>>=20> -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com> -->=20>=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/-------------------------------------------------------------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:
Tried both of those suggestions and it doesn't seem to like it :(Still getting getting [PRICE] which is supposed to be the last else if ther=eare no currencies as a variable.Any other takers?ThanksAlan=20on 12/4/03 4:16 PM, Brian Fries at webdna@brainscansoftware.com wrote:> When comparing text strings with an [if], you need to quote the values;> otherwise it attempts a numerical comparison:>=20> [if "[currency]"=3D"USD"]> etc...>=20> - brian>=20> On Dec 4, 2003, at 8:09 AM, Alan White wrote:>=20>> Hi folks>>=20>> I am having a little bit of difficulty with an [if] [else] statement.>> I am>> trying to check the variable [currency] and then display the relevant>> result>> based upon it.>>=20>> Here is the code which is performed within a [founditems] context:->>=20>> [text]USDcost=3D[math][PRICE]*[lookup>> db=3Dadmin/=20>> mycurrency.db&value=3DUSD&lookinfield=3Dcurrency&returnfield=3DexchangeRa>> te][/math][/text]>> [text]JPYcost=3D[math][PRICE]*[lookup>> db=3Dadmin/=20>> mycurrency.db&value=3DJPY&lookinfield=3Dcurrency&returnfield=3DexchangeRa>> te][/math][/text]>> [text]EURcost=3D[math][PRICE]*[lookup>> db=3Dadmin/=20>> mycurrency.db&value=3DEUR&lookinfield=3Dcurrency&returnfield=3DexchangeRa>> te][/math][/text]>>=20>> [if [currency]=3DUSD]>> [then]>> [text]priceDisplay=3D$[format 10.2f][USDcost][/format][/text]>> [/then]>> [else]>> [if [currency]=3DEUR]>> [then]>> [text]priceDisplay=3D=E2=82=AC[format 10.2f][EURcost][/format][/text]>> [/then]>> [else]>> [if [currency]=3DJPY]>> [then]>> [text]priceDisplay=3D=C2=A5[format>> 10.2f][JPYcost][/format][/text]>> [/then]>> [else]>> [text]priceDisplay=3D=C2=A3[format 10.2f][PRICE][/format][/text]>> [/else]>> [/if]>> [/else]>> [/if]>> [/else]>> [/if]>>=20>> ----------------->> The idea is that I then display the cost as follows:->>=20>> [priceDisplay]>>=20>> The [PRICE] gets displayed even when the various other currencies are>> passed>> into the page...>>=20>> Hope someone can help....>>=20>> Alan>>=20> -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com> -->=20>=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/-------------------------------------------------------------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/
Alan White
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:
Null Chars (1999)
pc (1997)
Mozilla/4. and Browser Info.txt (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
using cookies to prevent access (2000)
total number of matches (1999)
[WebDNA] FastCGI version confusion (2011)
has any written a WebDNA calendar that also writes iCalendar (2004)
PSC recommends what date format yr 2000??? (1997)
Re:multiple digests, please stop (1997)
6.0 Serial - Moving to New Server (2004)
autosensing lanague selection (1997)
Email address checker (2002)
setting the price of goods after its added to the cart (2000)
WebCatalog can't find database (1997)
[WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019)
Undeliverable Mail (1997)
Upgrading to 4.0 (2000)
LAST CHANCE! Anyone have a one-to-one messaging system? (1999)
WARNING: deletedb anomaly (2002)