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... - brian On 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:

    
  1. Re: if else problem ( John Peacock 2003)
  2. Re: if else problem ( Brian Fries 2003)
  3. Re: if else problem ( Kenneth Grome 2003)
  4. Re: if else problem ( Brian Fries 2003)
  5. Re: if else problem ( "RichC" 2003)
  6. Re: if else problem ( Alan White 2003)
  7. Re: if else problem ( Kenneth Grome 2003)
  8. Re: if else problem ( Alan White 2003)
  9. Re: if else problem ( Rob Marquardt 2003)
  10. Re: if else problem :- Version1 ( Donovan Brooke 2003)
  11. Re: if else problem: Version 2 ( "Erol Guneri" 2003)
  12. Re: if else problem: Version 2 ( Alan White 2003)
  13. Re: if else problem :- Version1 ( Alan White 2003)
  14. Re: if else problem ( Donovan Brooke 2003)
  15. Re: if else problem ( Alan White 2003)
  16. Re: if else problem ( Gary Krockover 2003)
  17. Re: if else problem ( Alan White 2003)
  18. Re: if else problem ( Brian Fries 2003)
  19. Re: if else problem ( Brian Fries 2003)
  20. Re: if else problem ( Alan White 2003)
  21. Re: if else problem ( Brian Fries 2003)
  22. Re: if else problem ( "Erol Guneri" 2003)
  23. if else problem ( Alan White 2003)
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... - brian On 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:

Server crash (1997) PCS Frames-Default page is solution! (1997) OT: OSX calculator error (2004) [WebDNA] Mac OS X 10.9.2 Webdna Installation Instructions (2014) Hide Cart ID in URL? (2003) Bug? (1997) Follow-Up to: Removing [showif] makes a big difference in speed (1997) POST Datamissing? (1998) Associative lookup style? + bit more (1997) [WebDNA] Search Problem (2011) 2.1 pricing? (1998) Price + Texte (1999) Admin Edit prob. (1997) Max Record length restated as maybe bug (1997) Emailer prefs in two places ... (1997) For those of you not on the WebCatalog Beta... (1997) RE: Any limit to [include] (1997) WebCat2.0 [format thousands .0f] no go (1997) Template not found error messages (1997) Too Much Rootbeer Free Offer (1997)