<%@ LANGUAGE="JSCRIPT" %>
<% connDB = Server.CreateObject("ADODB.Connection");
str = "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
str += Server.MapPath("registration.mdb");
Response.Write(str);
connDB.Open(str);
str = "SELECT * from students WHERE sid=";
str += Request.QueryString("sid");
// This is the detail page in a drilldown interface; one gets to this page
// by clicking on a link -- the primary key associated with the record is
// sid and is passed in the querystring to this page so that the select
// statement on this page will select only this record. Because only
// one record will be returned (because the primary key is unique)
// there is no necessity to loop through the recordset below.
rsItem = connDB.Execute(str); %>
| ID |
First Name |
Last Name |
State |
| <% =rsItem("sid") %> |
<% =rsItem("first") %> |
<% =rsItem("last") %> |
<% =rsItem("state") %> |
<% rsItem.Close();
connDB.Close() %>