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= e are no currencies as a variable. Any other takers? Thanks Alan=20 on 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:

    
  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)
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= e are no currencies as a variable. Any other takers? Thanks Alan=20 on 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:

WC Database Format (1997) Printing a final order (1997) still having shipCost.db Problem (1997) Listserver problem (1997) multiple search commands (1997) wish list (2002) Help with Shipping Costs (1997) Date and Time Analyzer (2000) New Mac Public Beta Available (1997) This is an odd error (2001) WC 4.0 on OSX 10.0.4 problems (2001) RE: Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) Include a big block of text (1997) Not really WebCat (1997) requiring form fields? (2000) WCS Newbie question (1997) Problems appending to database (1997) Help! WebCat2 bug (1997) taxrate - off by 1 cent (1997) WC2b15 File Corruption (1997)