if else problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54633
interpreted = N
texte = Hi folks 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 resul= t based upon it. Here is the code which is performed within a [founditems] context:- [text]USDcost=3D[math][PRICE]*[lookup db=3Dadmin/mycurrency.db&value=3DUSD&lookinfield=3Dcurrency&returnfield=3DexchangeR= a te][/math][/text] [text]JPYcost=3D[math][PRICE]*[lookup db=3Dadmin/mycurrency.db&value=3DJPY&lookinfield=3Dcurrency&returnfield=3DexchangeR= a te][/math][/text] [text]EURcost=3D[math][PRICE]*[lookup db=3Dadmin/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=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]=20 [/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 passe= d into the page... Hope someone can help.... Alan ------------------------------------------------------------- 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)
Hi folks 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 resul= t based upon it. Here is the code which is performed within a [founditems] context:- [text]USDcost=3D[math][PRICE]*[lookup db=3Dadmin/mycurrency.db&value=3DUSD&lookinfield=3Dcurrency&returnfield=3DexchangeR= a te][/math][/text] [text]JPYcost=3D[math][PRICE]*[lookup db=3Dadmin/mycurrency.db&value=3DJPY&lookinfield=3Dcurrency&returnfield=3DexchangeR= a te][/math][/text] [text]EURcost=3D[math][PRICE]*[lookup db=3Dadmin/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=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]=20 [/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 passe= d into the page... Hope someone can help.... Alan ------------------------------------------------------------- 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:

[OT] 'Email this story to a friend' (2003) Deleting Multiple Database Records based on Checkbox (1998) [WebDNA] Triggers issue, or sendmail? (2012) Req: Array Tags Explained, simple and clear (2004) hiding hyperlink info in URL field (1999) greater than or equal to (1997) Bit off subject -- Faxing orders (1997) [lookup] [search] Issue (2005) Problem 2: Prefs file... (1997) ShowNext (was New WebCatalog Site) (1997) Question re: FlushDatabases (1997) WebCat2b15MacPlugin - [protect] (1997) Tiger / WebDNA (2005) Limitations on fields? Server is crashing (1997) b12 cannot limit records returned and more. (1997) Emailer compatibility..... (1998) Mac Vs WindowsNT (1997) RE: 2nd WebCatalog2 Feature Request (1996) WebCat2 beta 11 - new prefs ... (1997) RE: Help name our technology! (1997)