To not repopulate another query with a sub query or to QoQ the data, I tend
to:
<!--- Some query that has 100 record --->
<cfquery datasource="#Request.Datasource#" name="qRead">
select
*
from
tableName
</cfquery>
<cfset start = 11>
<cfset end= 20>
<cfloop from="#start#" to="#end#" index="i">
<cfoutput>
#qRead.Addr_ID[i]#<br />
</cfoutput>
</cfloop>
Query objects can be referenced like arrays and thus you can loop or
paginate over the data set with predefined boundaries.
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 Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277852
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
