Replaced line breaks with <BR> 1

[tomomark]

Hi Everyone,

What i have is a record in a database, which when pulled looses all of its line break, and comes out as one long line . . . in the record, it maintains its line break etc.

Does anyone know how i replace line breaks with <BR> so when out pulled from database looks right . . .

. . . is it best to insert the <BR> before it goes into the database or when pulling it out?

Replace(varComments, chr(10), "<br />")

Mark

 

[Ecreations]

Before

Replace(VarComments,VBCRLF,"<br />")

after

Replace(VarComments,"<br />",VBCRLF)

Good luck

http://ecreationscanada.com

Note:Copying and Pasting is NoT Creativity.
What would you attempt to accomplish if you knew you would not fail?

 

[tomomark]

Hi . . .

Im sorry to bother you again, but it doesnt seem to be working . . . im sure its something im doing tho! Searched around alot, doesnt seem to be very well documented

<% 
Dim VarComments
VarComments = page_contents.FieldValue("page_code", Container)
Replace(VarComments,VBCRLF,"<br />")
Replace(varComments, chr(10), "<br />") 
response.write(VarComments)
%>

 

[Ecreations]

you trying to save the content or show it here?

http://ecreationscanada.com

Note:Copying and Pasting is NoT Creativity.
What would you attempt to accomplish if you knew you would not fail?

 

[tomomark]

ignore me, i sorted it out :S lol

<% 
Dim VarComments
VarComments = page_contents.FieldValue("page_code", Container)
Response.Write(Replace(varComments, VbCrLf, "<br>"))
%>
[/code

 

[Ecreations]

glad you did

good luck

http://ecreationscanada.com

Note:Copying and Pasting is NoT Creativity.
What would you attempt to accomplish if you knew you would not fail?