Phillip Yes and yes... however, like hitting queries within a loop, you should be careful or you will have a process that is slow and resource intensive - and therefore not maintainable in the long run. As far as the cfoutput query=""... that's no problem - except if you subsequently try to do a cfoutput within the cfoutput using a result set returned from the SP.
Mark -----Original Message----- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 2:23 PM To: CF-Talk Subject: Stored Procedure question Can you call to a stored procedure in a cfloop and have it work right? Can you call to a stored procedure in a cfoutput with the query named defined and have it work right? Trying to use stored procedures for the first time and they are really staring to tick me off. Grrrrrrrrr Thanks, Phillip Broussard Tracker Marine Group 417-873-5957 ______________________________________________________________________ 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 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
