Garth Young wrote: > > The problem I have is that the Coldfusion query is not returning as the > result set is too big. I could simply run the query pulling out blocks of > rows from it but this would require re-executing the SQL 6-7 times at least.
Use a cursor: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:49577/sort:2#265064 Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284535 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
