2 options :
1. select the MAX record from your SQL query, so you only have 1 record
result return, use the MAX() function.
2. <cfoutput query="#q#" startrow="1" maxrows="1">
----- Original Message -----
From: "Conrad, Christopher" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 11:16 AM
Subject: RE: One record query output
> Can you use the maxrows attr within cfquery ?
>
> Chris
>
> Christopher Conrad
> Senior.Programmer.Analyst
> Advanced.Technology.Group
> The.Limited.Inc
> http://www.limited.com
> (o) 614.415.1181
> (c) 614.523.0532
>
>
>
> -----Original Message-----
> From: Michael Gribbin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 10:10 PM
> To: CF-Talk
> Subject: One record query output
>
>
> Hi, I'm trying to find out if it's possible to limit the output of a query
> to one record. I have a database that is sorted in decending order and I
> only want the top record (the one with the biggest total) to display. I
can
> do a work-a-round by setting a variable to "on" before the query output
and
> turning it "off" after the first record is processed and then <cfif>
> skipping the rest of the records, but was hoping to do it in the query
it's
> self.
>
> Possible?
>
> Thanks in advance.
>
> Michael Gribbin
> Digital Marketing Alliance
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
