Skip navigation
wakeen
wakeen Calculating status...
Currently Being Moderated

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

Jul 12, 2012 5:06 AM

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!

721 Views   4 Replies   Latest reply: Dan Bracuk, Jul 13, 2012 9:45 AM
 
Replies
  • Dan Bracuk
    Currently Being Moderated
    1. Dan Bracuk,
    Jul 12, 2012 5:50 AM   in reply to wakeen
    Report

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

     
    |
    Mark as:
  • wakeen
    Currently Being Moderated
    2. wakeen,
    Jul 12, 2012 9:31 PM   in reply to Dan Bracuk
    Report

    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 :

    [code]

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

    [/code]

     

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

    [code]

    <h3 style=

    [/code]

    were saved.

     

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

     

    Any suggestions or help?

     

    Thanks.

     
    |
    Mark as:
  • wakeen
    Currently Being Moderated
    3. wakeen,
    Jul 13, 2012 1:26 AM   in reply to wakeen
    Report

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

     
    |
    Mark as:
  • Dan Bracuk
    Currently Being Moderated
    4. Dan Bracuk,
    Jul 13, 2012 9:45 AM   in reply to wakeen
    Report

    The problem might be the display of the record on a web page when you select it back.  You can run your query outside ColdFusion if you want.  Alternatively, on the page where you are attempting to display the record, view the html source code.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points