They probably meant (or should have said) that GoDaddy don't support <cfstoredproc>, which does run sp_prepexec for each result specified. It's pretty inefficient, but I think there is probably no other way to do multiple result sets through JDBC. This is the exact reason why I don't like and don't use cfstoredproc. It also seems like database storage client variables may do something like that... I don't exactly remember.
-nathan strutz http://www.dopefly.com/ On 5/5/06, Mark A Kruger <[EMAIL PROTECTED]> wrote: > > I second that John, > > They are misinformed. I suspect their information came from a > misconfigured > DSN setting. For example, If I set up a user "bob" and didn't change > "default database" for him, then I set up a JDBC connection without > specifying the database I wanted to connect to - it would try to connect > to > master (which is the default default database for any new user), but it > would fail because master doesn't allow direct manipulation of data. > Instead > it comes with a set of SP's (sort of a like an API) for making any > changes. > > I would be very surprised if their information was accurate. More to the > point, they are trading down when they deny cfqueryparam - not trading up. > A > site that doesn't user cfqueryparam is going to be less secure, slower, > and > will not be able to leverage the DB like it should. > > -mark > > > -----Original Message----- > From: Snake [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 11:57 AM > To: CF-Talk > Subject: RE: Coldfusion with Godaddy > > That's interesting, we have no such problem on our SQL servers, > CFQUERYPARAM > works fine, and every user only has access to their own database. > > > -----Original Message----- > From: John Rossi [mailto:[EMAIL PROTECTED] > Sent: 05 May 2006 17:47 > To: CF-Talk > Subject: RE: Coldfusion with Godaddy > > That's not entirely true. They do not, at least they told me they can't > allow me to use cfqueryparam with sql server in shared hosting. > > Here's the final response I got from them. > > After further researching the issue(s) at hand, we have determined the > following: > > The line "EXECUTE permission denied on object 'sp_prepexec', database > 'master', owner 'dbo'." shows that the database is attempting to work with > the master database of the server. Due to this, the cfqueryparam feature > will not work within our shared hosting environment SQL (though it should > work with a locally controlled Access database). We apologize for any > inconvience this may cause in regards to your site deployment. If you have > absolute need of this feature, you may wish to consider our Virtual > Dedicated or Dedicated server solutions. Bear in mind that these are not > managed servers. Previous server administration experience is recommended > should you opt to move to one of these solutions. > > Should you require further assistance on this or any other issue, don't > hesitate to contact us any time of the day or night at (480) 505-8877. Or, > if you prefer email, you can send your questions or comments to > [EMAIL PROTECTED] > > Sincerely, > Drew C. > Advanced Hosting Support > > -----Original Message----- > From: Brad Wood [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 12:37 PM > To: CF-Talk > Subject: RE: Coldfusion with Godaddy > > > They guy on the phone just told me that they support all tags out of the > box > except cfexecute and cfregistry > > He also said that they will not install custom tags for you, but I can > still > run it in my own directory, right? > > ~Brad > > -----Original Message----- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 11:31 AM > To: CF-Talk > Subject: RE: Coldfusion with Godaddy > > I would think they would. They had a help section about Coldfusion when > they > first released it. In fact, if you search this list on the website you > should be able to find my post with all of the direct links. > > <!----------------//------ > andy matthews > web developer > certified advanced coldfusion programmer ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > -----Original Message----- > From: Brad Wood [mailto:[EMAIL PROTECTED] > Sent: Friday, May 05, 2006 11:23 AM > To: CF-Talk > Subject: RE: Coldfusion with Godaddy > > > I'm on the phone now trying to get a list of restricted tags from them.. > Does any one know if they publish that? > > ~Brad > > -----Original Message----- > From: Brad Wood > Sent: Friday, May 05, 2006 11:04 AM > To: CF-Talk > Subject: RE: Coldfusion with Godaddy > > Godaddy does CF now? That is cool. I have asked them several times if > they > plan on hosting CF sites and they have always told me no. > > My personal site is pretty basic and I have been looking around for some > cheap hosting to move it to. Since my domains are already registered with > godaddy, I might give their hosting a whirl... > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239826 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
