Weird ASP/SQL Problem

Weird ASP/SQL Problem


Consider the following HTML Form, it has a textbox and a search button.

<form method=post action="search.asp">
<input name="txtName" type="text" id="txtEmail" />
<input type="submit" name="Submit3" value="Search" />
</form>

Code (markup):

The search.asp page:

select * from tbl_group_contact where userName ='"& request("txtName") &"'

Code (markup):

if I put this query in the search.asp page then it will search by name based on the name I entered in the textbox. But if I leave the textbox empty and click on the search button, SQL fetches all the rows from the table. If you havent noticed this before, try it now!!


Well, this is not my problem/question. my question is if I place a combo box instead of the textbox and assign a NULL value to one of the option field like:

<select name="txtType" id="txtType">
<option value="" selected="selected">All</option>
</select>

Code (markup):

and press the search button, then it does not fetch all the rows as it did for the empty textbox.

Any idea why?

 

This may not be the solution, but your code is wrong - only the word selected is required.

<select name="txtType" id="txtType">
<option value="" selected>All</option>
</select>

 

Also of course your text field is called txtName but your select box is called txtType

 

request("txtName") should be request.Form("txtName") - also protect it and trim it.

trim(replace(request.Form("txtName"),"'",""))