simple? not really, but here's one way <cfquery .etc> Select * from my normal database </cfquery>
<cfset offset=20> #get results 20 ~ 29 <cfset limit=10> <cfquery dbtype="query" maxrows = "#((offset-1)+limit)#" name="q1" > select * from dbtable order by some_field </cfquery> <cfquery dbtype="query" maxrows = "#limit#" name="q2"> select * from q1 order by some_field desc </cfquery> <cfquery dbtype="query" name="q3"> select * from q2 order by some_field </cfquery> On 5/11/07, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
