If u'r using CF (and that's the forum, right?)
AND YOU HAVE a colum where you put the date
of each INSERT just use this:
<cfquery name="x" datasource="y" MAXROWS="1">
SELECT colum from table ORDER by columthatholds_date
DESC</cfquery>
If u'r not holding the date of the insert, the MAX idea is good.
Thanks,
Michael Lugassy
Interactive Music Ltd.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists