>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?
You might try
<cfquery name="status" maxrows="1">
select side_1_comments
from status
order by datechanged desc
</cfquery>
That should get the record data with the most recent 'datechanged' date/time.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
