view contents of database

Hello all.
I am trying to have a web page list the contents of my database table. I have been trying for ever and cannot find what I am doing wrong.
Here is my code: (I hope it is not a mess I am new too this)I have included comments to walk myself through this.
<%@language="VBScript"%>
<%Option Explicit%>
<html>
<head>
<title>Complete Bug Database</title>
</head>
<body>
<%
'creating adodb.connection to connect to database, and setting connection to open
Dim connection
set connection=Server.CreateObject("ADODB.Connection")
connection.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &_
server.MapPath("data/Developers.mdb")
connection.Open

'Creating objrs as recordset to use to communicate with my database by putting my string that holds my sql statement in it
Dim ObjRS
Set objRS = Server.CreateObject("ADODB.Recordset")

'Create string to hold my sql command
Dim strSQL
strSQL = "SELECT * FROM tblbug"

'open recordset and communicate with database that I want to perform sql inside my string and to do it in my database in my connection
ObjRS.Open strSQL, connection

'Print out the results, stop trying when there is null entered and keep moving to next record
Do Until objRS.EOF = True
<table>
<tr>
<td>Response.Write "Ticket Number =" & objRS("ticketID")</td>
<td>Response.Write "Date =" & objRS("date")</td>
<td>Response.Write "Description =" & objRS("description")</td>
</tr>
</table>
objRS.MoveNext
Loop

'Close and empty my record set and my connection
objRS.Close
Set objRs=Nothing
connection.Close
Set connection=Nothing
%>
</body>
</html>

Thanks in advance for your help!

view contents of database

not working and cannot find errors

Blelisa

mattglet

aspdaddy

aspdaddy

mrMister

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week