<html>
<body>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "DSN=win.dsn"
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "Select CategoryID, CategoryName, Description From tblCategories Where CategoryID='2';", Conn
Response.Write(Rs("CategoryID") & "<br>")
Response.Write(Rs("CategoryName") & "<br>")
Response.Write(Rs("Description" ))
Rs.close
set Rs=nothing
Conn.close
Set Conn=nothing
%>
</body>
</html>&"<br>" 로 한칸씩 밀어내기
출력값
2
Condiments
Sweet and savory sauces, relishes, spreads, and seasonings
