% strBase = "http://www.lexurb.com/article.asp" Dim cn If isObject(Session("mdbDefined")) Then Set cn = Session("mdbDefined") Else Set cn = Server.CreateObject("ADODB.Connection") cn.Open "DSN=LEXURB" Set Session("mdbDefined") = cn End If Set cmd = Server.CreateObject("ADODB.Command") Set rs = Server.CreateObject("ADODB.Recordset") %>
| <%
If Request.QueryString("ID") <> "" And IsNumeric(Request.QueryString("ID")) = True Then
rs.Open "SELECT * FROM Articles WHERE ID=" & Request.QueryString("ID"), cn, adOpenStatic, adLockOptimistic
If rs.eof Then
response.write "The article you requested cannot be found."
else
' display record
%>
|
![]() |