|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
