> 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?
I haven't seen this exact error before, but I can affirm that you can, in fact, use both CFQUERY and CFSTOREDPROC within a single CFTRANSACTION. 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
