[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