I have re-written an app using all stored procedures and it still runs too slow (it's a series of parent-child query loops) so I'd like to move all conditional processing to the db and run it all in one sproc...
is this at all possible using referential cursors? Can I return conditional cursors? Basically either one result set, two result sets or four would return for each major record... Or am I going about this all wrong? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
