Hey again, Dave Watts assured me yesterday that I should be able to use CFSTOREDPROC and CFQUERY inside a CFTRANSACTION with the same datasource and have no problems. Thanks Dave ;-)
Now below is my original post and I am wondering if anyone has encountered a similar situation with a mix of CFSTOREDPROC and CFQUERY in a CFTRANSACTION?? Original Post: Hey All, I'm converting a whack load of common queries to stored procedures right now and I have started getting an error whining about trying to open a datasource that is already open. The situation is that in some of my cftransaction blocks I have a mix of included queries and included stored procedure calls (cfstoredproc) that all use the same datasource. Now eventually dang near every query will end up as a stored procedure, but in the meantime are there any suggestions on keeping this from happening? will this happen with multiple stored procedure calls from within a cftransaction? TIA for any insight Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
