Retrive data in Correct Format?

[sdakoju]

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?

[Fishdawg65]

This is a C-Sharp forum. Please move or post this in a different area.

[sdakoju]

I am sorry for this but I have no option for COLD FUSION here..I believe this is a problem with ORACLE DATABASE....Even If I am using ADO.NET to enter data into the database using one of the providers... I will have same problem.....ie "How can I retrive data in the same format as it is in the database?".... This can be a C# problem too..........Thank you for reading and replying.....

[sdakoju]

Solution1:
Have a play with: HTMLEditFormat, and HTMLCodeFormat, they will keep html format to a certain extent

This might also help http://wiki.fckeditor.net/

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

[petes1234]

I just did a google search on -- coldfusion forum -- and got over 3 million hits.... and you're posting this shít here? C'mon, get real!