That's great. Thank you both for your help.
-----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]
