Skip to main content
W
wakeen
Participant
July 12, 2012
Question

textarea (WYSIWYG text editor) - the html code generated won't save into my DB table.....

  • July 12, 2012
  • 1 reply
  • 1229 views

Hi CF guys,

I have a textarea form on my page...and I made my textarea field like an Editor for my content to be able modify(font,headings,alignment etc).

But when I'm about to insert it to my DB table, insert won't continue.

I've set my table column as LongText data-type....

I made some testing and debugging and found out that the problem is the generated code produced by my text editor. IS there any possible solution on this one? I badly needed to use the Text Editor and save values into my Database.

Any help or suggestions?

BTW...I used the Tiny MCE and the ckeditor 😃

Thanks!

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    July 12, 2012

    You said the insert won't continue.  What actually happens?  Do you get an error?

    W
    wakeenAuthor
    Participant
    July 13, 2012

    Nope I'm not gettin any error. And I found that the html generated code were not completely saved into my table column.

    For example, the generated html code were :

    <h3 style="color:blue;">
        Marriott to open first Sri Lankan property</h3>
    <p>
        <br />
        <strong>After</strong> signing an agreement with Weligama Hotel Properties Ltd, the Marriott Hotels & Resorts brand plan to open their first Sri Lankan hotel.</p>

    When I actual checked my table-column on the DB, only the

    <h3 style=

    were saved.

    That's the reason when I output the value on the page, the display is blank.

    Any suggestions or help?

    Thanks.

    W
    wakeenAuthor
    Participant
    July 13, 2012

    I have used now the  <CFQUERYPARAM> tag on my query insert,
    <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.f_content3#">
    but im still getting the same problem/issue.

    Any help please....

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices