Object doesn't support this property or method: 'EOF'
Object doesn't support this property or method: 'EOF'
Here's my code
<%
SQL = "SELECT * FROM Australia ORDER BY Player"
set DbConn = Server.CreateObject("ADODB.Connection")
DSName = Session("DSName")
DbConn.Open("DSN=pp2004;")
Set rs = Server.CreateObject("ADODB.Recordset")
rs = DbConn.execute(SQL)
%>
<HTML>
<HEAD>
<TITLE>View Players</TITLE>
</HEAD>
<BODY>
Players<hr>
<ul>
<%
do While NOT rs.EOF
%>
<li>
<%=rs("Player")%><br>
<%
rs.MoveNext()
loop
%>
%>
</ul>
</BODY>
</HTML>
I think it's because it does not know what rs is when I check EOF. But I have defined it with Set rs = Server.CreateObject("ADODB.Recordset") higher up, so how do I make sure rs is still known?
