TCX][MyODBC]You have an error in your SQL syntax near
----- Original MTCX][MyODBC]You have an error in your SQL syntax near essage -----
From: Nick Han
To: CF-Talk
Sent: Tuesday, February 17, 2004 1:21 PM
Subject: Re: query help...
select * from estates where featured = 1 and date_modified=(select max(date_modified) from estates)
Nick Han
>>> [EMAIL PROTECTED] 02/17/04 10:14AM >>>
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]
