<%@ Language=JScript %>
JScript and the ActiveX Data Object (ADO)
ActiveX Data Object (ADO)
<%
Conn = Server.CreateObject("ADODB.Connection")
Conn.Open("ADOSamples")
RS = Conn.Execute("SELECT * FROM Orders")
%>
<% for (i = 0; i < RS.Fields.Count - 1; i++) { %>
| <%= RS.Fields(i).Name %> |
<% } %>
<% while (!RS.EOF) { %>
<% for (i = 0; i < RS.Fields.Count - 1; i++) { %>
| <%= RS(i) %> |
<% } %>
<%
RS.MoveNext()
}
RS.Close()
Conn.Close()
%>