<blushes> Spot the clueless wonder Thanks all
Will ----- Original Message ----- From: "Jeffry Houser" <[EMAIL PROTECTED]> Newsgroups: gradwell.lists.cftalk Sent: Wednesday, February 13, 2002 4:12 PM Subject: Re: TOP 3 not working, again > 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 > > > > > ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
