Preserving Line Breaks in "text" data

Results 1 to 2 of 2

Thread: Preserving Line Breaks in "text" data

  1. #1
    Matthew Harvey Guest

    Default Preserving Line Breaks in "text" data

    I am storing text data in my SQL 7 database. If it has line breaks when entered into the web form, they are all gone when I retrieve the data.<BR><BR>Is there any way to preserve line breaks in text data?

  2. #2
    Join Date
    Dec 1969

    Default RE: Preserving Line Breaks in

    Convert them to something before storing the data and then convert them back when you extract it.<BR><BR>See the VBScript REPLACE function.<BR><BR>inText = Replace(inText,vbNewLine,"$NL$") &#039 before storing the data<BR>...<BR>outText = Replace(outText,"$NL$",vbNewLine) &#039 after getting data from DB<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts