or if you are using it in a <cfoutput query="YourQuery">, you can set
the 'startrow' to 'YourQuery.recordcount-1'
laszlo
Michael Dinowitz wrote:
>
> Order by something desc
> the order by sorts it, the something is whatever you use to track when a
> record went in and the desc says, sort it from last record first. Then just
> limit the CFQUERY to a maxrows of 2.
>
> > Hi,
> >
> > What SQL command do I use to obtain the last 2 records in a Table?
> >
> > Rgds
> >
> > Will
> > www.localbounty.com
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
