You aren't ordering your query, so who is to say what the top three records are?
If you want the newest three records, try something like this: SELECT TOP 3 ID, left(description, 15) as NewDescrip, * FROM thumbNailElements Order by thumbnailelements.ID desc At 03:22 PM 02/13/2002 +0000, you wrote: >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
