Adding a link in iRite box won't insert into ntext field?

Hi. I've got a standard textarea field which I converted to an iRite box to allow some basic formatting to be done.

Problem is when a user adds a hyperlink in the field, using the hyperlink toolbar command in iRite, and then tries to to submit it to our database we get the following error:

ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.

The textarea/iRite field is attempting to submit to an ntext field in the database.
If I remove the link, it submits fine so there is something about adding the link that causes the error.

Any ideas? Much appreciated.
Thank you.
Nath.

please send a copy of your page so I can examine the code.

Thanks Jason. That's attached now for you.

Any joy?

Any success with that Jason? Has me stumped. It submits fine when I remove the link!

try changing the following line:

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 255, Request.Form("NCnews")) ' adVarWChar

to:

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 500, Request.Form("NCnews")) ' adVarWChar

Hi Jason. Is that value the length of characters that are allowed?

yes, that is the character length for the parameter.

But it's an ntext field. I need to allow for an unknown amount of characters.
Why is adding something simple, like a hyperlink, causing this problem? I've never had to set the character length for an ntext field before.

the Dreamweaver insert record behavior will not be configured to allow for an unknown number of characters since it uses parameters in the query. One of the arguments that MUST be passed to the parameter is maximum length. This has nothing to do with the DB Column, it is a restriction to the ADO Parameter.


You can either set the parameter to use a very large max character setting:

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 5000, Request.Form("NCnews")) ' adVarWChar


or change to using the data assist insert record behavior which does not use parameters.

Why have I never encountered that before? I've created many INSERT and UPDATE commands that insert to, or update, an ntext field and I've never experienced this problem.

Also, as I've mentioned, this only happens when I use the "Insert Hyperlink" option in iRite. If I remove the link, I don't have to specify the number of characters in the parameter and I can insert/update any number of characters into the ntext field.

I'm certain the problem relates, in some way, to the insert link option in iRite.