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:323167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4