[thelist] SQL text form box
Daniel S. O'Shea
doshea at surfree.com
Tue Jun 26 23:35:18 CDT 2001
Stumped on a WROX ASP Databases SQL query. I get the return page, no errors,
it connects to DB, but even typing in a correct first name and last name in
the DB returns no records. The page's <h2> shows up, but no database
results. I altered the SELECT statement as the original code was for a
'dates between' query.
Trying to recreate a text box query. Here's the form (stripped of some
code):
STATFORM PAGE (statform.asp)
<form method="POST" action="StatResponse.asp">
<p>Please enter Last Name: <input type="text" name="LastName" size="11"></p>
<p>Please enter First Name: <input type="text" name="FirstName"
size="11"></p>
<p><input type="submit" value="Submit">
<input type="reset" value="Reset"></p>
</form>
...and here's the query, typing in first name and last name for a return of
that row (Email window may wrap some of this code):
STAT RESPONSE PAGE (statresponse.asp)
<body>
<h2>SQL for Recordsets</h2>
<%
varLastName = request.form("LastName")
varFirstName = request.form("FirstName")
dim ORSp
Set oRSp=server.createobject("ADODB.recordset")
sql = "SELECT People.PeopleNameLast, " & _
"People.PeopleNameFirst, " & _
"People.PeopleClubCode " & _
"FROM People " & _
"WHERE (((People.PeopleNameLast)='varLastName') AND
((People.PeopleNameFirst)='varFirstName'));"
oRSp.open sql, "dsn=sailors"
response.write "<table border=1>"
do while NOT oRSp.EOF
response.write "<tr><td>" & oRSp("PeopleNameLast") & "</td>"
response.write "<td>" & oRSp("PeopleNameFirst") & "</td>"
response.write "<td>" & oRSp("PeopleDOB") & "</td>"
response.write "<td>" & oRSp("PeopleClubCode") & "</td></tr>"
oRSp.MoveNext
Loop
response.write "</table>"
%>
</body>
Dan O.
More information about the thelist
mailing list