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
