Displaying SQL Server text

Results 1 to 2 of 2

Thread: Displaying SQL Server text

  1. #1
    Join Date
    Dec 1969

    Default Displaying SQL Server text

    I am storing a long text file in a 'text' datatype column in SQL Server 7. I need to display this text on a regular HTML page including all of the carriage returns that were included with the original text. Is there a way to do this? Currently, returning the text to an HTML page simply displays it as a long list of text. If it is displayed in a textarea, it shows the proper carriage returns.

  2. #2
    Join Date
    Dec 1969

    Default RE: Displaying SQL Server text

    Replace(str, vbcrlf, "<BR>")<BR><BR>j<BR>http://www.infinitemonkeys.ws/

Posting Permissions

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