Whoa! You lost me. You're making a procedure? If you post the query and or cursor, I'm sure we'd all have a better idea of what you need. This query that's returning a million rows, can you compile it as a stored procedure, and then call it passing a startrow and endrow to compare to rownum in the query?
-----Original Message----- From: Rodrigo Cohen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 3:32 PM To: CF-Talk Subject: Pagination issues Greg, i am making a procedure and sending a resultset from a cursor to ColdFusion. The problem is the query from my procedure... :) I am using the Cedric suggestion and it is working well... But i am still trying to find another way... Thanks ! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4