Basic HTML version of Foils prepared July 5 98

Foil 13 ASP - Example Code II

From FMS: Forces Modeling and Simulation Handout JSU HPC Summer Institute for Undergraduates, Jackson MS -- June 15 1998. by Wojtek Furmanski, Subhash Nair, Tom Pulikal


<!-- #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")
%>



© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Sat Nov 28 1998