[thelist] SQL text form box

Wed Jun 27 12:40:14 CDT 2001

Since I haven't seen a response, I'll chime in.

One glaring problem is in your sql WHERE:

"WHERE (((People.PeopleNameLast)='varLastName') AND
((People.PeopleNameFirst)='varFirstName'));"

Try -

"WHERE People.PeopleNameLast =" & varLastName & " AND People.PeopleNameFirst
=" & varFirstName

Do you see why?

That should get you moving.

> 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>