Robert O.
"Column name 'status.id' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause."
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 3:24 PM
To: CF-Talk
Subject: RE: Max id
try this...
Select TOP 1 MAX(ID), side_1_comments
from status
where datechanged = '#DateFormat(Now(), "mm/dd/yyyy")#'
group by side_1_comments
order by id DESC
tw
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 3:16 PM
To: CF-Talk
Subject: Max id
I have a table that will be updated daily. In the table I want to select
info from the latest record even if it is today's date. I used MAX(ID) to
get the latest record. Is that good or am I going about this wrong?
So far it doesn't seem to do that with my script below:
<cfquery name="status" datasource="status_internal"> Select MAX(ID),
side_1_comments from status Where datechanged = '#DateFormat(Now(),
"mm/dd/yyyy")#'
</cfquery>
Thx.
Robert O. (HWW)
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
