Oh ya... duh. I kept thinking of using functions to do it. Guess I need another cup of coffee.
Thanks! > -----Original Message----- > From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] > Sent: Thursday, June 04, 2009 11:11 AM > To: cf-talk > Subject: RE: reducing a query result > > > Query the query using the same query variable name. > > Adrian > > > -----Original Message----- > > From: Chad Gray [mailto:cg...@careyweb.com] > > Sent: 04 June 2009 16:07 > > To: cf-talk > > Subject: reducing a query result > > > > > > Say I have a query returned with 500 records. > > > > Is there a way in CF (not SQL) to reduce the query to only rows 1-50, > > 51-100 etc? > > > > I talking physically reducing the query object. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4