Extra line breaks in text fields

[mikepycroft]

I have a Livelink workflow which collects comments on a document. Using a HTML form the user sees all the previous comments and can add their own. The new comments are then concatenated onto the original ones using a JavaScript function. The comments are then stored as a workflow attribute.

This works fine but I have a mysterious problem that any line breaks / carriage returns the user enters in their comments are being duplicated each time the comments are updated by another users.


For example the original comments are:
First line
Second line

These are stored in the wf_attrib table as a ntext value and you can see an ascii(10) & ascii(13) characters to separate the 2 lines.

In the form I retrieve the comments using the WebReport command:
<INPUT TYPE="hidden" NAME="txt_orig" value = "[LL_REPTAG_&workid WFATTR:wf_mltxtISPLAY /]" >

However when I display the comments I see the following displayed:
First line
Blank line
Second line

Printing out the ascii values of the text string, txt_orig, it shows that the variable txt_orig now contains ascii(10) ascii(13) ascii(10) ascii(13) between the 2 lines of text.

Any ideas?

I am using Livelink 9.7.1 on an MS SQL server 2005 platform.