Error Executing Database Query only with goDaddy

[Inkfast]

Has anyone ever had this problem...

I have an Access db setup with a memo field to place news articles on a page. Anytime we try to write over 500 characters it throws the error below. Under 500 characters or with any other hosting company it works just fine.

Error Executing Database Query.
Application uses a value of the wrong type for the current operation.

The error occurred in D:\Hosting\whateverpath\add-news.cfm: line 3

1 : <cfinclude template="include_CheckAuthority.cfm">
2 :
3 : <cfinsert datasource="whateverdatasource" tablename="News">
4 :
5 : <cfset loginpage = "news.cfm?Message=" & URLEncodedFormat("News item added!")>

SQL insert into News (NEWSAUTHOR,NEWSCONTENT,NEWSTITLE) values ( (param 1) , (param 2) , (param 3) )
DATASOURCE whateverdatasource
SQLSTATE  

I have spent hours on the phone with these folks and it's clear no one there knows anything about cfserver at all. They shouldn't even be running it in my opinion.

Thanks!
David

[Newsgroup_User]

i agree that godaddy should not really be offwering cf hosting unless
they are prepared to go the whole mile with support as well...
but what's the actual error you get? you didn't include it in your post...

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[Newsgroup_User]

Try this:

<cfquery name="rsAdd" datasource="whateverdatasource">
INSERT INTO News
(NEWSAUTHOR, NEWSCONTENT, NEWSTITLE)
VALUES
(
<cfqueryparam value="#Trim(FORM.NEWSAUTHOR)#" cfsqltype="cf_sql_clob" maxlength="65535">,
<cfqueryparam value="#Trim(FORM.NEWSCONTENT)#" cfsqltype="cf_sql_clob" maxlength="65535">,
<cfqueryparam value="#Trim(FORM.NEWSTITLE)#" cfsqltype="cf_sql_clob" maxlength="65535">
)
</cfquery>


--
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com


"InkFasT!" <webforumsuser@macromedia.com> wrote in message news:es53lu$804$1@forums.macromedia.com...
> Has anyone ever had this problem...
>
> I have an Access db setup with a memo field to place news articles on a page.
> Anytime we try to write over 500 characters it throws the error below. Under
> 500 characters or with any other hosting company it works just fine.
>
> Error Executing Database Query.
> Application uses a value of the wrong type for the current operation.
>
> The error occurred in D:\Hosting\whateverpath\add-news.cfm: line 3
>
> 1 : <cfinclude template="include_CheckAuthority.cfm">
> 2 :
> 3 : <cfinsert datasource="whateverdatasource" tablename="News">
> 4 :
> 5 : <cfset loginpage = "news.cfm?Message=" & URLEncodedFormat("News item
> added!")>
>
> SQL insert into News (NEWSAUTHOR,NEWSCONTENT,NEWSTITLE) values ( (param 1)
> , (param 2) , (param 3) )
> DATASOURCE whateverdatasource
> SQLSTATE  
>
> I have spent hours on the phone with these folks and it's clear no one there
> knows anything about cfserver at all. They shouldn't even be running it in my
> opinion.
>
> Thanks!
> David
>

[Inkfast · Accepted solution]

Thanks for the reply Ken, that fixed it alright. I'm going to have to remember that one!