********************************************************************** 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
