Nathan, If you don't use cfstoredproc, what do you do? Just exec the sp in a cfquery tag? Just curious because I've been going through an old application doing the opposite.
Thanks, Greg On 5/8/06, Nathan Strutz <[EMAIL PROTECTED]> wrote: > > 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:239885 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
