Forums
This topic is locked
Large amounts of text with Advanced HTML Editor
06 Aug 2007 20:28:55 Armen M posted:
DW CS3 / ASP VBScript / SQL Server 2005 / Advanced HTML Editor extensionI get the following error everytime i try and insert a large amount of text into my database using the Advanced HTML Editor:
*****************************************************
ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/manage/news_html.asp, line 81
*****************************************************
Here's line 81:
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 201, 1, 7168, Request.Form("editor1") ' adLongVarChar
I've tryied using data types of TEXT and VARCHAR(MAX) in the database but the error persists. Any idea's as to what else i can do to be able to save larger amounts of text in my SQL Server database?
Replies
Replied 06 Aug 2007 20:44:45
06 Aug 2007 20:44:45 Armen M replied:
If anyone's intrested... I think i found the solution.
It seems the 7168 in line 81 is the number of charecters. By increasing thie number i was able to insert larger blocks of text.
It seems the 7168 in line 81 is the number of charecters. By increasing thie number i was able to insert larger blocks of text.