Hello All,

I am trying to display some text into textarea from an SQL query. It is a website where if a user wants to edit his profile info, the textarea will display his current description and he/she can edit it and update. Right now if a user goes to the edit page, it shows a blank textarea and the user has to type in the whole info even if they have already filled it in when they registered. I am using SQL query to retrieve the values from SQL server 2000. The query returns all the results fine when I run it in query analyzer. Here is how I try to display the text into textarea.

************************************************** ****************

<textarea name="AboutYou" maxlength="1500" cols="45" rows="7" class="Input-Error">
<%
MsgBody = Replace(TRIM(ORs("AboutYourself")), "<br>", CHR(13))
Response.write RTrim(MsgBody)
%>

</textarea>
************************************

I will be really thankfull to you all.