omg... I _cannot_ believe I didn't think of this.
Thanks and I'll try and keep from 'tarding out like this again. :]
Mike
>-----Original Message-----
>From: Will Swain [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 5:50 AM
>To: CF-Talk
>Subject: RE: getting last 3 records...
>
>
>How about:
>
><cfquery name="getrecords" datasource="datasourcename" maxrows="3">
> SELECT *
> FROM tbl_whatever
> ORDER BY primarykey DESC;
></cfquery>
>>> Hi,
>>>
>>> I need to get the last 3 (newest) records entered into my table.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
