TCX][MyODBC]You have an error in your SQL syntax near
----- Original Message -----
From: Tony Weeg
To: CF-Talk
Sent: Tuesday, February 17, 2004 1:24 PM
Subject: RE: query help...
select * from estates where featured = 1 and date <= (select
max(date_modified) from estates where featured = 1)
maybe?
-----Original Message-----
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 1:15 PM
To: CF-Talk
Subject: query help...
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]
