Hi Torrent, Perhaps by running the query on the server using a stored proceedure?
Take a look at this guide: http://www.adobe.com/devnet/coldfusion/articles/stored_procs.html It looks so good I'll be using it myself, lol Jenny Gavin-Wear Fast Track eCommerce +44 (0) 1262 602013 http://www.ftol-ecommerce.com/ >>-----Original Message----- >>From: Torrent Girl [mailto:[email protected]] >>Sent: 20 June 2011 14:32 >>To: cf-talk >>Subject: Re: Retrieve data in groups >> >> >> >>>Select TOP doesn't work in MySQL. You have to use Limit 0, N where N= >>>the number of records you want to return >>> >>> >>>>> Any suggestions? >> >>I am using MS SQL. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
