I have written an ASP application that searches a database for telephone numbers. The person will enter the full last name or a partial last name and the script will return all the appropriate records sorted by last name. What I would like to do is to provide the users with a dropdown list that gives the user the choice to search by either last name or first name. The user will choose his search criteria (Last or First names)then will enter either full/partial last name or full/partial first name in a text. The script should bring back the results based on those criteria. Any help on how to get about that will be appreciated. Thanks.
Assuming you got the choice back in your asp page into a variable I'll call bLastName, do something like
... ... strSql = "SELECT * FROM table WHERE " If bLastName = True Then strSql = strSql & "LastName LIKE '%" & Request.Form("text") & "%'" Else strSql = strSql & "FirstName LIKE '%" & Request.Form("text") & "%'" End If
Besides the error HuwR pointed out, you are using the 'get' method on your form, so I don't think Request.Form() is picking anything up. You can insert a response.write Request.Form("DaInBox") to check.
Topic Locked
Posted - 07 May 2001 : 19:23:45
