You have to trim the query using RemoveRows. In fact Ben Nadel wrote a function for it a while back if I remember correctly. Check his blog and search for query of queries.
Steve Brownlee http://www.fusioncube.net/ ----- Original Message Follows ----- From: [EMAIL PROTECTED] (Michael Dinowitz) To: CF-Talk <[email protected]> Subject: QofQ to get a limited set of rows Date: Fri, 11 May 2007 15:43:29 -0400 > Lets say I have a query that returned 100 items. I'd like > to do a query of queries to create a query that is only > items 11-20. Does anyone know a simple way of doing this > or do I have to create a new query and populate it using > a loop? > > Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
