asked on

In Classic ASP, How do I display ?

Hello.
In Classic ASP coding, I used this coding below to display 
Description = replace(rs("Description"),chr(13) & chr(10)," ")

But here is the problem.
In this page there are many rs("Descriptoin") and since I replace the rs("Description") into Description, it's displaying same description in the page.

What do I have to do?

Ashish Patel

Use this and let me know
Description = Replace(Replace(Replace(rs("Description"), vbCrLf," "), vbCr, " "), vbLf, " ")

Sven

If there is displaying the same description over an over again, are you sure you are calling rs.MoveNext ? Or am I totaly missunderstanding your question?

erin027

ASKER

Thank you asvforce.
But the problem didn't solve.
 works, but my problem was because of the replacement, recordset is showing same results.
Here is my coding.
Thank you.

<% if rs.BOF or rs.EOF then %>
<%else
Description = Replace(Replace(Replace(rs("Description"), vbCrLf," "), vbCr, " "), vbLf, " ")
i=1
Do until rs.EOF
%>

<%=rs("title")%>
<%=description%>

<%
rs.MoveNext
i=i+1
loop
End if
%>

ASKER CERTIFIED SOLUTION

Ashish Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

erin027

ASKER

Thank you!

Rajesh Dalmia

instead of storing value in variable and then print better u do this

instead of

<%Description = Replace(Replace(Replace(rs("Description"), vbCrLf," "), vbCr, " "), vbLf, " ") %>
<%=description%>

do redirectly

<%=Replace(Replace(Replace(rs("Description"), vbCrLf," "), vbCr, " "), vbLf, " ") %>

In Classic ASP, How do I display &lt;br&gt; ?

In Classic ASP, How do I display <br> ?