OK I got this one cased...when I went back and re-created the error it hit
me....I'm a moron ;-) Sometimes I wonder if my head is leaking or
something...geesh. I was passing the username and password (for SQL Server)
in the CFSTOREDPROC and don't have a user/pass setup for the datasource in
CF Admin because the db server and web server are the same machine
(therefore not required). DOH! So CF was complaining about me using
different user/pass info for the same datasource. I guess I should read
those error thingys more thoroughly..lol...turkey overload...brain
slooooowwwwwing dooooooowwwwwwwnnnnnnnnnnnnn
here was the error:
Error Diagnostic Information
More than one data source used in a CFTRANSACTION
The use of multiple data sources (or multiple username/password
attributes for a single data source) within a CFTRANSACTION is not
permitted. You have attempted to submit an SQL statement to the data source
'MAVERICK' while you have a transaction open for the data source 'MAVERICK'.
Data Source = "MAVERICK"
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (11:1) to (11:66) in
the template file
C:\INETPUB\WWWROOT\DEV\MAVERICK\DEMO3\ZONE\BUYERS\PURCHASE\ACCEPTED\QUERIES\
QRECALLORDER.CFM.
Date/Time: 12/28/01 12:08:25
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461)
Remote Address: 64.180.77.111
HTTP Referrer:
http://www.maverickevolutions.com/demo3/zone/buyers/purchase/accepted/stop_o
rder.cfm?Order_ID=564
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
----- Original Message -----
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 12:02 PM
Subject: RE: RE-POST: stored procedures and cftransaction
> > 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
>
______________________________________________________________________
Why Share?
Dedicated Win 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=coldfusionc
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
