Wow, I wasn't expecting quite such a response to my original email! All I wanted was the correct syntax, which I have gratefully received from this group. In my case, the page is a one-off that gets called about 5 times a day, so I'm not going to lose any sleep over CFIF or IIf or Java, but I will bear the performance issues in mind for larger sites with more usage!
Thanks Karl -----Original Message----- From: EWS [mailto:[EMAIL PROTECTED] Sent: 22 January 2004 08:18 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Nested IIf functions Touche monsieur pussycat !!!! lol On Thu, 22 Jan 2004 02:24:56 -0000, Snake Hollywood <[EMAIL PROTECTED]> wrote: > Personally I wouldn't go around quoting what other people say, I prefer > to > have my own opinions based on knowledge and fact form my own experience. > > I could tell you Iraq have no weapons of mass destruction if I were to > take > the quote of a certain madman and repeat it back to you. But we all know > that isn't true. > > Russ Michaels > Macromedia/Allaire Certified ColdFusion Developer > > CFDeveloper > The free resource and community for ColdFusion developer. > http://www.cfdeveloper.co.uk > > Join the CFDeveloper discussion lists. > To subscribe send an e-mail to [EMAIL PROTECTED] > > >> -----Original Message----- >> From: EWS [mailto:[EMAIL PROTECTED] >> Sent: 21 January 2004 18:24 >> To: [EMAIL PROTECTED] >> Subject: Re: [ cf-dev ] Nested IIf functions >> >> >> I would take that point up with Ben Forta whom I got the >> statement from >> originally. >> >> On Wed, 21 Jan 2004 16:18:29 +0000, >> <[EMAIL PROTECTED]> wrote: >> >> > >> > what if you had say 100 sites, each with 100 pages. in >> each of those >> > pages >> > you use IIF where you could have used something faster. >> each site gets >> > thousands of hits a day. could that not have a cumulative >> effect on cf >> > server's performance? >> > >> > the whole point of writing code that is marginally faster in >> > performance than something else, isn't because it's >> super-duper faster >> > on one run-through, or that you're only meant to use it in nested >> > loops. it's to improve overall performance in the long >> run, isn't it? >> > >> > >> > Duncan Cumming >> > IT Manager >> > >> > http://www.alienationdesign.co.uk >> > mailto:[EMAIL PROTECTED] >> > Tel: 0141 575 9700 >> > Fax: 0141 575 9600 >> > >> > Creative solutions in a technical world >> > >> > >> ---------------------------------------------------------------------- >> > Get your domain names online from: >> http://www.alienationdomains.co.uk >> > Reseller options available! >> > >> ---------------------------------------------------------------------- >> > >> ---------------------------------------------------------------------- >> > >> > >> > >> > "Snake >> > Hollywood" To: >> > <[EMAIL PROTECTED]> >> > <[EMAIL PROTECTED] cc: >> > kepit.net> Subject: >> RE: [ cf-dev ] >> > Nested IIf functions >> > >> > 21/01/2004 16:14 >> > Please respond >> > to dev >> > >> > >> > >> > >> > >> > I hate when people start this. >> > You will only see any overhead if you use hundreds of IIF >> statements in a >> > page or in some sort of nested loop. Otherwise the >> difference is too >> > small >> > to notice, it wont even make a 1ms difference to your page >> if you have a >> > cfif instead of an IIF. >> > >> > Russ Michaels >> > Macromedia/Allaire Certified ColdFusion Developer >> > >> > CFMX Hosting >> > Phone: 0845 456 3487 >> > Tech Support: 0906 9607800 >> > FAX: 0709 2212 636 >> > WEB: cfmxhosting.co.uk >> > >> >> Please use the support helpdesk on our web site to submit support >> >> tickets. >> > < >> > >> > Join our ColdFusion Developer discussion lists. >> > Send an e-mail to [EMAIL PROTECTED] >> > >> > >> >> -----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] >> > >> > >> > >> > >> > >> > >> >> >> >> -- >> ** 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] -- ** 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]
