Showtable.asp outlines the data structure of the table "Data"
The structure of the showtable.asp script is as follows:
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
2
<HTML>
3
<HEAD>
4
<TITLE>Pictures Table</TITLE>
5
</HEAD>
6
<BODY>
7
<Table border=1>
8
<tr>
9
<td>UID</td>
10
<td>LName</td>
11
<td>FName</td>
12
<td>Picture</td>
13
</tr>
14
<%
15
Set db = Server.CreateObject("ADODB.Connection")
16
dbPath = "DBQ=" & Server.MapPath("pictures.mdb")
17
db.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & dbPath
18
sqlCommand = "SELECT * FROM Data"
19
Set dbRs = db.Execute(sqlCommand)
20
do While Not dbRs.EOF
21
%>
22
<tr>
23
<Td><%= dbrs.Fields("UID")%></td>
24
<td><%= dbRs.Fields("Lname")%></td>
25
<td><%= dbRs.Fields("Fname")%></td>
26
<Td><%= dbRs.Fields("Picture") %></td>
27
<%
28
dbRs.MoveNext
29
Loop
30
%>
31
</tr>
32
<%
33
dbrs.close
34
set dbrs = nothing
35
db.Close
36
Set db = Nothing
37
%>
38
</table>
39
</BODY>
40
</HTML>