|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
search form with SQL Server 7 not working |
|
From: |
Aaron Longnion |
|
Date: |
10/16/2000 6:58:07 PM |
|
IP: |
206.13.56.104 |
Using ASP, SQL Server 7, and html text forms for a search.
1.) the ASP page works perfectly for the first five forms, and the "EXP_DT" field is used in one of those forms. The info. from EXP_DT field is displayed perfectly
there, but not for the final form, which is supposed to be displayed from the following code:
Go to the sixth form
ElseIf Request("EXP_DT") <> "" Then
Create a recordset object instance, and excecute the SQL statement
Set rsEXP_DT = Server.CreateObject("ADODB.Recordset")
rsEXP_DT.Open strEXP_DTSQL, connSearch
Determine whether there are any matching records in rsEXP_DT
If rsEXP_DT.EOF then
No records were returned for the characters entered by the user
Response.Write "There are no people whose License expires on " & strEXP_DT
Else
There are one or more EXP_DTs that match the users input, so display those numbers and corresponding
fields
Response.Write "<B>Information for people whose License expires on " & strEXP_DT & ":</B><BR><BR>"
Do While Not rsEXP_DT.EOF
Response.Write "<B>Name: </B>" & rsEXP_DT("Last") & ", " &_
rsEXP_DT("First")& " " & rsEXP_DT("Mid") & "<br>" &_
"<B>UID: </B>" & "<A HREF=""details.asp?uid=" _
& rsEXP_DT("UID") _
& """>" _
& rsEXP_DT("UID") & "<br>" _
& "</A>" & "<B>EXP_DT: </B>" & rsUID("EXP_DT") & "<BR><HR><BR>ð/LM/W3SVC/3/Root |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
