That's really strange... You're the only person I've talked to yet who's had that behavior... at least, that I'm aware of. Everyone else I've talked to who's tried to use cfquery for stored procedures on MX without using the ODBC socket drivers has said they couldn't return record sets -- and I remember reading from this list someone said ( and I think they were from MM ) that the JDBC drivers just didn't support the feature that allowed it to be done with the ODBC drivers. Not to mention that, although I don't work with MX yet, I was able to install an application on it briefly several months ago and noticed that the cfquery syntax wasn't returning any recordsets then.
Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > Yes, I have run the updater, but the stored procedure > worked before the > updater as well. > -----Original Message----- > From: S. Isaac Dealey [mailto:info@;turnkey.to] > Sent: Saturday, October 19, 2002 12:09 PM > To: CF-Talk > Subject: RE: cfstoredproc behavior > Have you run the MX Updater? They may haved worked around > the issue with the > JDBC drivers in the updater. >> Yes, many of my stored procedures return recordsets and >> are working just >> fine. I think not being able to return recordsets would >> be a HUGE >> limitation. I can't imagine that this would be the case. >> Again, when I >> created my datasouce I chose the SQL Server datasource >> type from the drop >> down menu. There is no mention of whether or not it is a >> JDBC, but I tend >> to believe it is because ODBC Socket was another option >> also on the drop >> down list. Can anyone else confirm or deny this >> behavior? >> Andy >> -----Original Message----- >> From: S. Isaac Dealey [mailto:info@;turnkey.to] >> Sent: Saturday, October 19, 2002 7:20 AM >> To: CF-Talk >> Subject: RE: cfstoredproc behavior >>> I'm pretty sure it's the order that is hanging it up. I >>> have used >>> cfstoredproc in other places on our servers and it works >>> just fine. >>> It's pretty dissapointing that this seems to be a >>> "feature" or "bug" or >>> whatever you want to call it that MM is ignoring. What >>> happens when you >>> want to skip parameters in a dynamic statement like I >>> was >>> doing, I guess you >>> have to revert to cfquery? >> Or you have to include all the parameters you wanted to >> skip ... Which means >> you can't allow the stored procedure to use its defaults. >> In my case most of >> my stored procedures use NULL for any defaults, so >> passing >> null="yes" in the >> <cfstoredproc> is equivalent, however, if I used "bilbo" >> as a default for >> instance, I'd have to pass "bilbo" as the value, which >> thoroughly defeats >> the purpose of having a default in my stored procedure >> and >> makes my job that >> much harder if that "default" value ever changes. >>> Also, what is the deal with cfquery in CFMX? I've just >>> finally got CFMX >>> installed tonight for the first time. Our website which >>> is probably 95% >>> cfquery vs. cfstoredproc seems to be working just fine. >>> For a datasource I >>> just chose SQL Server from the list of datasource types >>> when I created it, I >>> think this means I'm using the JDBC driver? Either way, >>> all of our stored >>> procedure calls that are made in cfquery tags seem to be >>> working fine. >> Hmmm... do many of your stored procedures return a >> recordset? That's the >> only issue really, so if you only use the stored procs to >> perform inserts >> and updates and aren't concerned with getting a recordset >> back, there >> wouldn't be any reason to notice the difference. >> Otherwise, you may be using >> the ODBC socket -- I wouldn't know, I've been too busy >> with recent updates >> and preparing for MX to actually install MX and work with >> it much. I suppose >> it's possible MM could have found a way to change the >> behavior with the JDBC >> drivers in the recent MX update though again I wouldn't >> know. >>> Personally, I have always preferred the cfquery tag over >>> the cfstoredproc >>> for the simple reason that you get real error messages >>> back and not just >>> "Unknown Data Access Error". >> Not to mention all that extra typing. :) >> Though iirc, it does have some other advantages in that I >> believe it's >> supposed to help speed up processing of stored procedures >> ( I wonder if this >> is done by not naming parameters ;P ) and it insulates >> the >> procedure from >> unlikely sql insertion attacks and issues with data >> insertion, like the \ on >> MySQL ( although current versions of MySQL don't support >> stored procedures ) >> being a special character that <cfquery> doesn't know to >> account for. Of >> course, much of this can also be accomplished with >> <cfqueryparam> in a >> stored procedure called with <cfquery> so my biggest >> gripes are the lack of >> ability to use db defined defaults and the fact that it's >> completely >> undocumented anywhere on MM's site ( actually the >> documentation says that >> the dbvarname attribute is supposed to be the name of the >> parameter in the >> stored procedure, which you might be able to weasel out >> of >> saying is an out >> and out lie, but it's certainly seems to indicate that >> the >> order of >> parameters shouldn't matter ) and since I may not >> necessarily be the only >> developer who ever touches my code there's a good chance >> at some point that >> I'm going to have to field technical support calls or >> emails in which I'll >> have to explain this whole debacle over again. >> Isaac >> Certified Advanced ColdFusion 5 Developer >> www.turnkey.to >> 954-776-0046 >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> ~ >> ~~~~~~~~~~~| >> Archives: >> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 >> Subscription: >> http://www.houseoffusion.com/index.cfm?sideb >> ar=lists&body=lists/cf_talk >> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >> Get the mailserver that powers this list at >> http://www.coolfusion.com > Isaac > Certified Advanced ColdFusion 5 Developer > www.turnkey.to > 954-776-0046 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/index.cfm?sideb > ar=lists&body=lists/cf_talk > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
