Response.write strsql does not yield desired sql statement

[Jack]

Hi,
I am trying to check for the final sql statement before passing it to a
database. I want to build the statement using user input in three text boxes.
However, the sql statement does not give me the right statement. Instead it
gives the following message:
Error Type:
Request object, ASP 0102 (0x80004005)
The function expects a string as input.
/sailors/loginverification1.asp, line 14
CODE:
<%
strSQL = "select PeopleNameFirst, PeopleNameLast, PeopleClubCode from People
where " & _
"PeopleNameFirst ='" & Request.Form(txtFirstName) & "' AND " & _
"PeopleNameLat ='" & Request.Form(txtLastName) & "' AND " & _
"PeopleClubCode ='" & Request.Form(txtPassword) & "'"
Response.Write strSQL
%>
Please note that line 14 is the first statement in above sql. Looking for
any advise on where the problem of the sql is. Thanks.

 

[Jeff Dillon]

Should be Request.Form("txtFirstName")

(in quotes)

 

[Jack]

Thanks for pointing out the mistake. I overlooked it altoghther. Regards.