Forums

ASP

This topic is locked

Large amounts of text with Advanced HTML Editor

Posted 06 Aug 2007 20:28:55
1
has voted
06 Aug 2007 20:28:55 Armen M posted:
DW CS3 / ASP VBScript / SQL Server 2005 / Advanced HTML Editor extension

I 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.

Reply to this topic