format text(blob) output from sql7 CR/LF to <BR>

Results 1 to 2 of 2

Thread: format text(blob) output from sql7 CR/LF to

  1. #1
    john doucette Guest

    Default format text(blob) output from sql7 CR/LF to

    I have an existing SQL7 db that has recipies previously entered.<BR><BR>When I view a detail of the text(blob) column, all formatting is lost. <BR><BR>I wish to use font tags to make it nice, but without <BR>&#039s I&#039ll have to use &#060;PRE&#062; to show line breaks.<BR><BR>Any Ideas on how to format the text (replace?) on the way out of the table into the browser?<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    29

    Default RE: format text(blob) output from sql7 CR/LF to
    Try using a filter...<BR>like this...<BR><BR>Function Filter(content)<BR> content = replace(content, chr(10), "<BR>")<BR>End Function<BR><BR>then do a<BR><BR>Call Filter(your_variable_here)<BR><BR>this at least puts breaks into your text...<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
  •