----- Original Message -----
From: Burns, John
To: CF-Talk
Sent: Tuesday, February 17, 2004 1:53 PM
Subject: RE: query help...
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]
