Question: 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?
Answer: 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.
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. Source: CoolInterview.com
Rules to Post Answers in CoolInterview.com:- There should not be any Spelling Mistakes. There should not be any Gramatical Errors. Answers must not contain any bad words. Answers should not be the repeat of same answer, already approved. Answer should be complete in itself.
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.