> 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?
Fortunately (for me at least) I still haven't encountered this problem. Can you show the exact error message? You might also consider some alternatives - you might move all your transactional processing to stored procedures, for example. I'd recommend this, if possible. You can still reuse SQL queries by placing them within their own stored procedures, and have your transactional procedure simply call those other procedures. In the meantime, you might leave the inline SQL in place in your CF app until you've converted all of the queries within a single transaction (and converted the transaction as well). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get Your Own 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=coldfusionb 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
