|
<!-- #Include file="utils.asp" --> <!--include file containing some variable declarations-->
|
|
<!-- The file that lists the classes in the left frame // sp_classes_list.asp --->
|
|
<html>
|
|
<head><title>Speedes Database - sp_classes_table Table List</title></head>
|
|
<body bgcolor="#ffffff">
|
|
<%
|
|
Dim selid, clsid
|
|
selid = request.querystring("id") 'get the id from the querystring
|
|
if(selid = "") then
|
|
selid = 1
|
|
end if
|
|
` open up a database connection and execute the SQL query
|
|
Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
|
|
OBJdbConnection.Open "speedes"
|
|
` select id and name of all classes from the classes table
|
|
SQLQuery = "SELECT clsid,cname FROM sp_classes_table"
|
|
`execute the SQL query and get the resultset
|
|
Set typelist = OBJdbConnection.Execute(SQLQuery)
|
|
%>
|
