I think they probably never really got the point of my initial support
request. I haven't tried cfstoredproc yet because none of my clients sites
use it, but there is definitely a problem with cfqueryparam, and sql server
on my account at least. but The following query
<cfquery name="qryTest" datasource="#app_dsn#">
SELECT *
FROM tblSites
WHERE intSiteID=<cfqueryparam cfsqltype="cf_sql_integer" value="6">
</cfquery>
Fails with the following error
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]EXECUTE permission denied on
object 'sp_prepexec', database 'master', owner 'dbo'.
The error occurred in <snip>: line 34
32 : SELECT *
33 : FROM tblSites
34 : WHERE intSiteID=<cfqueryparam cfsqltype="cf_sql_integer" value="6">
35 : </cfquery>
36 :
Its clearly a configuration issue on their end, but I am sure cfstoredproc
will probably also fail. Like I said in an earlier message, I am going to
submit another tech support request about it and reference this thread along
with some of the other blogs about cfqueryparam, and Sean Cornfield's blog
on their ColdFusion hosting in general.
John
-----Original Message-----
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 1:11 PM
To: CF-Talk
Subject: Re: Coldfusion with Godaddy
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:239839
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
