wouldn't personally do it, but not knowing oracle, that was the best
suggestion I could come up with.
John Burns
-----Original Message-----
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 3:12 PM
To: CF-Talk
Subject: RE: query help...
> Well, if you do top 1 you would not want dates desc or the first one
> would be the newest (right?).
Oops, I mis-read, the desc was in there as I thought he wanted the
newest <g>
> Other than that, you
> could just return the whole query (if there's no sort of top syntax
> for your DB it'll work, even though it's not very
> resourceful) and just do <cfoutput query="blah" startrow="1"
> maxrows="1"> and that would just output the first record.
One word - YUK!
Do you know what a "maxrows" does?
What you're suggesting is that he returns EVERY record from the set to
CF - this could be millions of records if it's some sort of tracking
data
It's much faster to get the SQL engine to get the single record than to
risk the entire recordset being passed
Let the SQL engine to the "heavy lifting" and let CF do what it's there
for - to do dynamic output and logic!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
