J
J P Singh
Hi All
I have been asked to build a search page to allow users to search the
database. The issue is that the search page in ASP must mirror out existing
search screen on the VB application.
I need to give a search screen which will have lots of dropdowns and free
text fields. I want to dynamically build a search query to include fields
that the user chooses to enter something in.
For example I might have fields like this on form
Name
Area
EmpNumber
Gender
Postcode
The user enters name and postcode
I would like to create a query like this
Select * from info where name like request.form("Name") and Postcode like
request.form(Postcode)
but if the user only entered his name the query should be
select * from info where name like request.form("Name")
does anyone know how this can be done.
cheers
Jas
I have been asked to build a search page to allow users to search the
database. The issue is that the search page in ASP must mirror out existing
search screen on the VB application.
I need to give a search screen which will have lots of dropdowns and free
text fields. I want to dynamically build a search query to include fields
that the user chooses to enter something in.
For example I might have fields like this on form
Name
Area
EmpNumber
Gender
Postcode
The user enters name and postcode
I would like to create a query like this
Select * from info where name like request.form("Name") and Postcode like
request.form(Postcode)
but if the user only entered his name the query should be
select * from info where name like request.form("Name")
does anyone know how this can be done.
cheers
Jas