MySQL Forums
Forum List  »  Connector/ODBC

Can't insert/update more than 595 chars with ASP
Posted by: Martin van Vugt
Date: November 09, 2004 03:55AM

I'm having some trouble inserting/update a LONGTEXT column. I'm using the following code:

mainconn = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=81.173.116.191;DATABASE=jaegershuys;UID=jaegershuys;PASSWORD=jaegershuys;"

Set rs_newmenu=Server.CreateObject("ADODB.Recordset")
rs_newmenu.Open "menumain", mainconn, 1, 3, 2
rs_newmenu.Filter = "menuID="&rmid&" AND lang = "&lang
rs_newmenu("type_menu") = Request("type_menu")
rs_newmenu("parent") = Request("parent")
rs_newmenu("rang") = rang
rs_newmenu("name") = Replace(request("name"),"'","’")
rs_newmenu("blop") = Request("m1_HTMLContent"),
rs_newmenu("form_id") = request("form_id")
rs_newmenu("map_id") = request("map_id")
rs_newmenu.update
rs_newmenu.Close
Set rs_newmenu=Nothing

This is the error is receive:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Bij een OLE DB-bewerking die uit meerdere stappen bestaat, zijn fouten opgetreden. Controleer alle OLE DB-statuswaarden als deze beschikbaar zijn. Er is niets gewijzigd.


I found out that i can't insert more than 595 characters using this connection. Can anyone help me out with this?

Options: ReplyQuote


Subject
Written By
Posted
Can't insert/update more than 595 chars with ASP
November 09, 2004 03:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.