|
-
February 11th, 2004, 06:59 AM
#1
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?
-
February 11th, 2004, 07:19 AM
#2
Solved it. Needed Set rs = instead of rs = !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
