You need to add an ORDER BY statement to order the results in the order you desire....
SELECT TOP 3 ID, left(description, 15) as NewDescrip, * FROM thumbNailElements ORDER BY ID DESC Russel > -----Original Message----- > From: W Luke [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 13, 2002 9:23 AM > To: CF-Talk > Subject: TOP 3 not working, again > > > Why does TOP rarely work for me? I just need to grab the last 3 records, > but instead it pulls the same 3 each time, regardless of whether there are > newly inserted records or not > > <Cfquery name="latestphotos" maxrows=3 datasource="#ds#"> > SELECT TOP 3 ID, left(description, 15) as NewDescrip, * FROM > thumbNailElements > </CFQUERY> > > Any ideas? > > Thanks > > Will > > > --- > "A woman drove me to drink and I didn't even have the decency to thank > her." --W.C. Fields > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
