Advanced HTML Editor 3 Support Product Page
Answered
Max characters?
Asked 04 Aug 2014 18:59:09
1
has this question
04 Aug 2014 18:59:09 Ed Stewart posted:
I get this error when my text approaches 1000 characters:ADODB.Command error '800a0d5d' Application uses a value of the wrong type for the current operation.
Replies
Replied 05 Aug 2014 08:52:36
05 Aug 2014 08:52:36 Teodor Kuduschiev replied:
Hello Ed,
This has nothing to do with Advanced HTML Editor. The error shows that the content you are trying to insert is bigger than the maximum database field size. Make sure to setup your database fields types properly.
This has nothing to do with Advanced HTML Editor. The error shows that the content you are trying to insert is bigger than the maximum database field size. Make sure to setup your database fields types properly.
Replied 05 Aug 2014 11:56:32
05 Aug 2014 11:56:32 Ed Stewart replied:
I understand what the error means. Nevertheless, the error is generated when my data approaches 1000 characters, and the field datatype is varChar(MAX). I am able to insert several thousand characters manually into the field without error, but when using your extension, the error is generated.
Replied 05 Aug 2014 12:11:55
05 Aug 2014 12:11:55 Teodor Kuduschiev replied:
Please be a little more detailed - which is the extension you are referring to: "when using your extension, the error is generated."
Replied 05 Aug 2014 13:07:58
05 Aug 2014 13:07:58 Ed Stewart replied:
I'm using Advanced HTML Editor 3.3.1. Is this not the right forum for this?
Replied 05 Aug 2014 13:11:00
05 Aug 2014 13:11:00 Teodor Kuduschiev replied:
How do you store the content into the database? Are you using DMXzone Database Updater or are you using the Dreamweaver Server behaviors?
Replied 05 Aug 2014 14:48:01
05 Aug 2014 14:48:01 Ed Stewart replied:
Dreamweaver server behavior. Is this an issue?
Replied 05 Aug 2014 14:56:30
05 Aug 2014 14:56:30 Teodor Kuduschiev replied:
No, this shouldn't be an issue. Still - the error you see is caused by the fact the insert record tries to insert more characters than the field length is... And this is a server error not front-end one,