Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Output data not spacing properly

Status
Not open for further replies.

tthandle

IS-IT--Management
Joined
Nov 21, 2001
Messages
3
Location
US
I am having a problem using a form to I am using a form to upload data from ASP to SQL Server 2000 hosting site. When I see the data it looks fine however when a sql is run to return the data the data is compressed. How can I return the data as I see it using the SQL Query Analyzer. For example when I am loading the data it looks like this:
The boy ran down the street.

The girl followed.

The boy ran further.

The data appears exactly as you read it with blank lines using the SQL Query Analyzer. However, when it is return it displays:
The boy ran down the street. The girl followed. The boy ran further.

I would like the blank lines to remain. I am using ntext in the column. (column_name,ntext,16)

Please help.

Thanks in advance!
 
How you return your data? In ASP pages? If you want to view your data in ASP pages, you can add this code at each row:

response.write rs (&quot;your data&quot;) & &quot;<br><br>&quot;
------------------
Freedom is a Right
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top