Why set anything? If you're down to this simple of a decision (0 or 1), I
would run the query, then use the variable RecordCount in my output since it
already exists. Like so...
<cfif QueryName.RecordCount IS 0>
do stuff
<cfelse>
don't do stuff
<cfif>
Tony Gruen
sfnetworks
-----Original Message-----
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 3:55 AM
To: CF-Talk
Subject: RE: Writing efficient CFIF statements
**********************************************************************
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**********************************************************************
Yeah, I like that idea. Thanks I think I'll try and use it.
Cheers.
> ----------
> From: Tim Painter[SMTP:[EMAIL PROTECTED]]
> Sent: 16 July 2002 11:51
> To: CF-Talk
> Subject: Re: Writing efficient CFIF statements
>
> IIF is slower. Couldn't you just do:
>
> <cfset QueryResults = myQuery.Recordcount>
>
> If recordcount is 0, it would be false anyway
>
> ----- Original Message -----
> From: "Adrian Lynch" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 16, 2002 6:36 AM
> Subject: RE: Writing efficient CFIF statements
>
>
> > Looks cleaner, but isn't it slower?
> >
> > -----Original Message-----
> > From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]]
> > Sent: 16 July 2002 11:31
> > To: CF-Talk
> > Subject: RE: Writing efficient CFIF statements
> >
> >
> > Any opionions on:
> >
> > <CFSET QueryResults = IIF(myQuery.RecordCount EQ 0, DE("False"),
> > DE("True"))>
> >
> > ?
> >
> > Cheers, Hugo
> >
> >
> > -------------------------------------------------------------
> > Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
> > Project Officer Phone: +46 8 7410451
> > UNEP GRID-Arendal Fax: +46 733 403285
> > Stockholm Office Mobile: +46 733 467111
> > WWW: http://www.grida.no
> > -------------------------------------------------------------
> >
> >
> >
> > | -----Original Message-----
> > | From: Tim Painter [mailto:[EMAIL PROTECTED]]
> > | Sent: Tuesday, July 16, 2002 12:19
> > | To: CF-Talk
> > | Subject: Re: Writing efficient CFIF statements
> > |
> > |
> > | Stephen,
> > | I usually like to set things either "true" or "false".
> > | (or 1 or 0). The true or false is a little more visual, I
> > | think -- so to use your example, I would do it like:
> > |
> > | <cfif myQuery.RecordCount EQ 0>
> > | <cfset QueryResults = false>
> > | <cfelse>
> > | <cfset QueryResults = true>
> > | </cfif>
> > |
> > | <cfif QueryResults>
> > | There are records
> > | <cfelse>
> > | No records to display
> > | </cfif>
> > |
> > | This is reverse of yours (if there are no records, then the
> > | variable is false -- your example shows as true) To me it
> > | made more sense to have that variable false.
> > |
> > | Of course, you can bypass the whole cfif and use the
> > | myQuery.RecordCount and test whether that is true/false:
> > | <cfif myQuery.recordcount>
> > | There are records
> > | <cfelse>
> > | No records to display.
> > | </cfif>
> > |
> > |
> > |
> > | ----- Original Message -----
> > | From: "Adams, Stephen" <[EMAIL PROTECTED]>
> > | To: "CF-Talk" <[EMAIL PROTECTED]>
> > | Sent: Tuesday, July 16, 2002 5:08 AM
> > | Subject: Writing efficient CFIF statements
> > |
> > |
> > | >
> > | **********************************************************************
> > | > WESTMINSTER CITY COUNCIL
> > | > Please refer to the disclaimer beneath this message
> > | >
> > | **********************************************************************
> > | >
> > | > Hi,
> > | >
> > | > I am trying to put more structure into my CF code. My idea
> > | is to separate
> > | > the ColdFusion processing from the HTML structure and use
> > | CSS for the look
> > | > of the site. I am trying to get an idea of what is the
> > | best way to separate
> > | > the CF. I know that I could use custom tags, user defined
> > | function and if I
> > | > was using MX, then components. But these are for code that
> > | can across used
> > | > in multiple pages. What I am talking about is the CF for
> > | an individual
> > | > page.
> > | >
> > | > What has all this to do with CFIF statements, well. I was
> > | thinking of
> > | > setting a series of flags that are checked against in my
> > | HTML. The CFIF
> > | > statements are there to check the value of these flags and
> > | amend the page
> > | > depending on these flags. So I want to be able to write
> > | good efficient CFIF
> > | > statements so that my code is up to speed.
> > | >
> > | > Here's an example of what I am talking about:
> > | >
> > | > <!--- Default ColdFusion Parameters --->
> > | > <cfparam name="QueryResults" default="" type="string">
> > | >
> > | > <!--- ColdFusion Processing --->
> > | > <cfquery name="myQuery" datasource="myDSN">
> > | > SELECT *
> > | > FROM myTable
> > | > </cfquery>
> > | >
> > | > <!--- Sets flags --->
> > | > <cfif myQuery.RecordCount EQ 0>
> > | > <cfset QueryResults = 1>
> > | > </cfif>
> > | >
> > | > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> > | >
> > | > <html>
> > | > <head>
> > | > <title>Untitled</title>
> > | > </head>
> > | >
> > | > <body>
> > | >
> > | > <cfif QueryResults EQ "1">
> > | > <table cellspacing="2" cellpadding="2">
> > | > <tr>
> > | > <td class="mainFont">Results found.</td>
> > | > </tr>
> > | > </table>
> > | > <cfelse>
> > | > <table cellspacing="2" cellpadding="2">
> > | > <tr>
> > | > <td class="mainFont">No results found.</td>
> > | > </tr>
> > | > </table>
> > | > </cfif>
> > | > </body>
> > | > </html>
> > | >
> > | > This is a simple example, but it shows how I want to keep
> > | the processing
> > | > separate at the top of the page.
> > | >
> > | > My question, finally, is how are CFIF statements best
> > | written if I want to
> > | > code this way and or is there a better way of writing my CF code.
> > | >
> > | > Thanks.
> > | >
> > | >
> > | >
> > | **********************************************************************
> > | > Westminster City Council switchboard:
> > | > +44 20 7641 6000
> > | >
> > | **********************************************************************
> > | > This E-Mail may contain information which is
> > | > privileged, confidential and protected from
> > | > disclosure. If you are not the intended recipient
> > | > of this E-mail or any part of it, please telephone
> > | > Westminster City Council immediately on receipt.
> > | > You should not disclose the contents to any other
> > | > person or take copies.
> > | >
> > | **********************************************************************
> > | >
> > | >
> > |
> >
> >
> >
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
