ASP - Example Code II
<!-- #Include file="utils.asp" --> <!--include file with certain variable declarations-->
<html><head><title>Speedes Database - sp_classes_table Record</title></head>
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 -->