ASP/mySQL record updating problem for TEXT fields
Hi there,

I'm running the mySQL v4.0 under Windows Server 2003

I'm currently in the process of convering a website which was running on an Access database across to one running off mySQL. When the data was converted (using accessDump) the MEMO fields in Access were converted to TEXT fields in mySQL

I've got all the data ported and the updates to the ASP scripts are going well but I've just hit a snag.

I have this code
....
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Application("cardbConnectionString")

Set rsDetails = CreateObject ("ADODB.Recordset")
sql = "select description, allowComments, memberOnlyComments from user where userid=1"

rsDetails.Open sql, conn, 3, 3

rsDetails.Fields("allowComments") = 0
rsDetails.Fields("memberOnlyComments") = 0
rsDetails.Fields("description") = request("description")

rsDetails.update
....

The request("description") simply pulls somethings through from TEXTAREA on a HTML form. All this worked fine with access but fails on the 'description' line when I try it against mySQL giving this error

------------------
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/tc/member_edit_process.asp, line 101
-------------------

If I hard code the line to
rsDetails.Fields("description") = "hello world"

it works fine.

The field type for this record in mySQL is TEXT.

Do I need to coerce the data from the form element to something before assigning it to the field.

Any help would be great