----- Original Message -----
From: Burns, John
To: CF-Talk
Sent: Tuesday, February 17, 2004 2:30 PM
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?). 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.
John Burns
-----Original Message-----
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 2:17 PM
To: CF-Talk
Subject: Re: query help...
I think this has been the closest yet... but still no work. =(
----- Original Message -----
From: Philip Arnold
To: CF-Talk
Sent: Tuesday, February 17, 2004 2:04 PM
Subject: RE: query help...
select top 1 *
from estates
where featured = 1
Order by date_modified desc
> From: Daniel Farmer [mailto:[EMAIL PROTECTED]
>
> This is my query...
>
> select * from estates where featured = 1 and
>
> [ I want to select the oldest date_modified field here ]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
