Max id

[Robert Orlini]

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]

---