#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]
