Hi all,

I've got a web page on which the user enters some text. The text can (and frequently does) have basic formatting (such as carriage returns for paragraphs, etc.). The text is stored in my database and maintains the basic formatting. The problem occurs when I retrieve the data to display on a subsequent web page - all the basic formatting is gone (no paragraphs, etc TEXT and I'm getting the information from a resultset object using the getString() method. Is there some other method I should be using to maintain the basic formatting?

Scott

Also how to respond to the thread, so I'll put it here: the first TIMESTAMP column in a table is special in that when a record is created, this column is automatically populated with the record creation date and time (insert a null for the value in that column); later, the column is automatically updated whenever any columns in that row are changed. Other TIMESTAMP columns in the table don't behave that way - it's only the first. AND - the modification date/time is only changed if the column(s) changes to a different value - e.g. it is not updated if column values are "updated" with their current values. So want to use this functionality, you'll have to add a TIMESTAMP column to the table.