>> 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? >>
There is an interesting method that I stumbled upon, it's quite a bit more compact than rebuilding the whole query: - Create an array the same length as your query has rows, call it "rownum" -- rownum[1]=1, rownum[2]=2 etc. - Attach it to your query using queryaddcolumn(myquery,"rownum",rownum) - Now you can QoQ where rownum > #start# and rownum <= #end# -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
