Skip to main content
S
susheel_dakoju
Participant
July 25, 2007
Question

Retriving data in correct Format

  • July 25, 2007
  • 2 replies
  • 364 views
I am working on a website which uses COLD FUSION and ORACLE. I have few forms on this website. The user has to cut and paste large volumes of data(20 to 30 pages) in the text areas. I am using CLOB data type for this. Everything goes fine! The data is stored in the data base. The format is fine when I viewing it in the database

But if I am trying to retrive that data and see it in a browser with in a text area, I can hardly read anything..The format has changed, no spacing... Everything comes up in a single line? The problem araises when you cut and paste Curriculum Vitaes. The bullets dont even show up?

Is there any way I can save the formatting either using COLD FUSION OR ORACLE? Is there any thing I need to do with Record Formatting? Please help me out! Thank you?
This topic has been closed for replies.

2 replies

N
Newsgroup_User
Inspiring
July 25, 2007
But what kind of formatted text is stored in the database? I'm
suspecting that it is plain ASCII text with carriage returns and such.
If this is so, then HTML does not understand this kind of text and
ignores such formatting characters. To have HTML honor tabs, carriage
returns and multiple whitespace characters from plain text one uses the
<pre> or <code> tags.

S
susheel_dakojuAuthor
Participant
July 25, 2007
Thanks for your solutions! Both of them worked well. I could get most of the work done. Thank you once again!
M
Mattastic
Inspiring
July 25, 2007
Have a play with: HTMLEditFormat, and HTMLCodeFormat, they will keep html format to a certain extent

This might also help http://wiki.fckeditor.net/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices