jqxEditor issue, adds a special character at the end of text

[rashmeeprakashParticipant]

I am using JqWidgets Text Editor on a web application. When I update and save my data to the database, it automatically adds a “?” at the end. Is there a solution to get rid of this. Please help!

Here is my code:

HTML:

<textarea id="theDesc" form="confForm" rows="10" cols="62" name="conf_desc" style="display: block; margin : 0 auto; margin-left: 0px;">#conf_desc#</textarea>

jQuery

$('#theDesc').jqxEditor({
        height: "250px",
        width: '515px'
    });

SQL

INSERT INTO CONFERENCES(...,CONF_DESC,...)
VALUES(...,<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#attributes.conf_desc#">, ...)

On Save this is what i get:

The ‘?’s are not there in the form values. They only show up once the description is added into the database.

[ivailoParticipant]

Hi rashmeeprakash,

You can test of your value about containing of this character before to be inserted in your database.
You can print it in your server script and if the value not contains this symbol the problem goes to be in your SQL settings.
If the symbol is in your value, then it goes to the frontend.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts