How do assign the memo data type in ASP page as variable? and I want to place that variable in HTML's textarea as its value?

S.P.Murugesan
Profile Answers by S.P.Murugesan Questions by S.P.Murugesan
Oct 28th, 2005
1
2155

Showing Answers 1 - 1 of 1 Answers

rachna

Dec 15th, 2005

I tried it with the access database with description as memo field.
<%@LANGUAGE="VBSCRIPT"%>
<%
set conn=server.CreateObject("ADODB.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.MapPath("db1.mdb") & ";"
set rs=server.CreateObject("ADODB.recordset")
rs.open "select * from table1",conn
desc=rs(1)
%>
<html>
<body>
<textarea><%=desc%></textarea>
</body>
</html>
You can also try it with sql database. I am sure it wud work.