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.
| >
| **********************************************************************
| >
| >
|
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
