problem with insert to memo field

[rami1972]

I've moved a web site that I manage from a CF server 5 to CF MX.

I didn't change anything in the database itself, the memo field are configured
fine.

Since then, I have a problem to insert more than 300 charecters into memo
fields, if I insert more than 300, this is what I get:

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

The error occurred in D:\hshome\yes-od\yes-od.com\shal.cfm: line 58

56 : <cfset form.quest = ReplaceNoCase(form.quest,Chr(34),"'","ALL")>
57 :
58 : <cfinsert datasource="yes-od_lalo" tablename="ask" formfields="quest,
email, fName, lName, sdate">
59 : <br>
60 : <br>

Anyone can help?

Thanks


--------------------------------------------------------------------------------

SQL insert into ask (quest,fName,lName,sdate) values ( (param 1) , (param 2)
, (param 3) , (param 4) )
DATASOURCE yes-od_lalo
SQLSTATE &nbsp;

[sdittbrenner]

1. What kind of database? Oracle, MS-SQL, FoxPro ...?
2. Run the query in a try-catch block and look what kind of SQL-error details
you can gather. Perhaps you must use <cfqueryparam> to fix your problem.

[rami1972]

1. it's an access datebase
2. I don't know how to do it, but I'll try to find out.

Thanks

[rami1972]

well, couldn't fix it... anyone have a clue?

[rami1972]

ok, it's fine now, i changed the syntax from cfinser to a simple SQL insert statment...

thanks!