ASP - Example Code I
<!-- #Include file="utils.asp" --> <!--include file containing some variable declarations-->
<!-- The file that lists the classes in the left frame // sp_classes_list.asp --->
<head><title>Speedes Database - sp_classes_table Table List</title></head>
selid = request.querystring("id") ’get the id from the querystring
‘ 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)