My apology for not having asked Dan what DB he was using.
Nick Han
>>> [EMAIL PROTECTED] 02/17/04 10:53AM >>>
Why not select them ordered by date_modified and then just use the first
record? Or if you're worried about passing all of that data back and
forth you can use TOP (or whatever corresponds to your DB server)
John Burns
-----Original Message-----
From: Steve Milburn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 1:51 PM
To: CF-Talk
Subject: Re: query help...
Daniel Farmer wrote:
> This is my query...
>
> select * from estates where featured = 1 and
>
> [ I want to select the oldest date_modified field here ]
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Daniel Farmer
> Coldfusion Developer / Sales / Producer
> 613.284.1684
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
