Re: [ cf-dev ] Nested IIf functions

EWS Wed, 21 Jan 2004 03:45:40 -0800

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]

Re: [ cf-dev ] Nested IIf functions

Reply via email to