SQL Server Line Feeds

[itflash]

Hi all

My app reads fields from a SQL Server Back End using ADO recordsets.

One of the fields is a ntext type. When I use my desktop application to populate it, it shows line feeds (ie where the user pressed enter). In SQL Server it shows the line feeds.

However, when I response.write the field, it puts it onto one line.

Is there any way of overcoming this?


Example.

The user types and is saved into SQL Server as such:
1
2
3
5

ADO recordset displays on ASP page
1 2 3 4 5



Thanks
ITflash

 

[itflash]

OK - done it.


tempvar=myrecset("notesfield&quot
if not isnull(tempvar) then
tempvar=replace(tempvar(chr(13), &quot;<BR>&quot
response.write(tempvar)
end if


Unless there are other suggestions?