<!-- #Include file="utils.asp" --> <!--include file with certain variable declarations--> |
<html><head><title>Speedes Database - sp_classes_table Record</title></head> |
<body bgcolor="#ffffff"> |
<% |
Dim id,cname,SQLQuery,listurl |
id = request.querystring("id") ` get the id of the record to display |
` open a database connection and execute the query |
Set OBJdbConnection=Server.CreateObject("ADODB.Connection") |
OBJdbConnection.Open "speedes" |
SQLQuery = "SELECT * from sp_classes_table where clsid = " & id |
Set typelist = OBJdbConnection.Execute(SQLQuery) |
if typelist.EOF then ` check if there are any records |
%><!-- There are no sp_classes_table records --> |
<% |
else |
cid = typelist("clsid") |
%> |