I just tested it on MX and it works the same.
Tim P.
----- Original Message -----
From: "Stephen Moretti" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 7:05 AM
Subject: Re: Writing efficient CFIF statements
> > Looks cleaner, but isn't it slower?
> >
> > >
> > > Any opionions on:
> > >
> > > <CFSET QueryResults = IIF(myQuery.RecordCount EQ 0, DE("False"),
> > > DE("True"))>
> > >
>
> IIF is supposed to be a little inefficient, but its like all these things.
> Its probably take a couple of milliseconds longer, so it really makes no
> difference.
>
> I'm not sure I agree with the "looks cleaner" comment though. Sure, its on
> one line, but its not the easiest thing to read. I use IIF a reasonable
> amount, but given the choice. I'd go with cfscript instead....
>
> To be honest, in Stephen's simple case, you don't need the logic to set
> QueryResults to true or false, you can just do this.....
>
> <cfif myQuery.RecordCount>
> <!--- Got some records --->
>
> <cfelse>
> <!--- Got no records --->
>
> </cfif>
>
> CF will take anything that is greater than 0 to be TRUE and 0 to be FALSE.
> (Haven't checked what happens with negative numbers in a while, so couldn't
> possibly comment)
>
> A word of warning about this though.... You'd be better using
> myQuery.RecordCount GT 0, as I'm not sure that CFMX will take
> myQuery.RecordCount as a BOOLEAN when it is greater than 1.
>
> Regards
>
> Stephen
>
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
