... and is marginally easier to debug and add validation/error handling to if you don't use iif()'s. But, I agree, all is not black and white in the land of programming.
- Peter -----Original Message----- From: EWS [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 10:44 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Nested IIf functions Just a quick point. IIF is great but use sparingly. If possible use CFSWITCH of CFIF as IIf does have a greater processing overhead. If this is not possible then IIf is fine and does a great job. Just a thought On Wed, 21 Jan 2004 10:34:25 -0000, Tomo Smith <[EMAIL PROTECTED]> wrote: > > #IIf(GetPatients.wait_time_mins[i] GT 381000, > DE("red"), 'IIf(GetPatients.wait_time_mins[i] GT 375000, DE("orange"), > DE("blue"))')# > > try the iif statement above. I changed your DEs to use double quotes, > and > your inner IIF has single quotes around it, otherwise it wont work! > > Cheers, > > Tom > > > > ----- Original Message ----- > From: "Osullivan Karl (RKB) Senior Analyst/Programmer" > <[EMAIL PROTECTED]> > To: "CF - Development Group" <[EMAIL PROTECTED]> > Sent: Wednesday, January 21, 2004 10:27 AM > Subject: [ cf-dev ] Nested IIf functions > > >> >> UHCWT Logo >> >> >> Hello >> >> Is it possible to nest IIf statements, as I'm trying to do the >> following: >> >> style="background-color:#IIf(GetPatients.wait_time_mins[i] GT 381000, >> DE('red'), IIf(GetPatients.wait_time_mins[i] GT 375000, DE('orange'), >> DE('blue')))#;" >> >> However, when I run this, the following message appears >> >> >> Variable orange is undefined. >> >> >> >> Is my syntax wrong? I thought it looked okay. Obviously the above is >> within a <CFOUTPUT> tag. >> >> >> >> >> Karl O'Sullivan >> Senior Analyst/Programmer >> >> Computer & Network Services >> UHCW NHS Trust >> Clifford Bridge Road >> COVENTRY >> CV2 2DX >> >> Contact: >> Tel (internal): 28952 >> Tel (external): +44 (0) 24 7696 8952 >> Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> Web: www.uhcw.nhs.uk <http://www.uhcw.nhs.uk> >> >> >> >> >> >> > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
