I've made a page that checks if a recordset is empty or not. If it's empty it parses a sentence, if it's not empty it loops thru the recordset and parses it all... But When I do this, I get an error. That the object (my recordset) doesn't support eof or bof.
This is my code:
Visit
This is my code:
Code:
<!--#include file="../include/connectioninc.asp"-->
<%
SQL = "SELECT * FROM tbl_content WHERE contentID = " & request.querystring("id") & ""
RShome = conn.execute(SQL)
%>
<html>
<head>
<title>::: Leujel :::</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../_css/3.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
If Not RShome.eof Then
Do While Not RShome.EOF
response.write("<table width=""100%"" cellpadding=""0"" cellspacing=""0"">")
response.write("<tr>")
response.write("<td><b>" & RShome("contentkop") & "</b></td>")
response.write("</tr>")
response.write("<tr>")
response.write("<td height=""15""></td>")
response.write("</tr>")
response.write("<tr>")
response.write("<td>" & RShome("content") & "</td>")
response.write("</tr>")
response.write("</table>")
RShome.MoveNext
Loop
Else
response.write("<tr>")
response.write("<td>Sorry er zijn geen entries gevonden.</td>")
response.write("</tr>")
END IF
%>
</body>
</html>
<!--#include file="../include/conncloseinc.asp"-->Visit