Thats Sql Server only (access too?) . <cfquery maxrows=1> might be better
Justin
<cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC">
> Select top 1 *
> from UnitPages
> where ArticleUnit = '#form.units#'
> order by ArticleDate DESC
></cfquery>
>
>This will literally return the top row, and nothing else
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
