Search

[leeny]

i've been given a task to come up with a search engine. this search engine searches based on a few conditions such as the category, the item properties,unit,etc. more of an advanced search. i haf a database with several tables and i was wondering how to allow user to select a table and narrow down the search on that particular table? how does the sql statement goes?

for eg,

Search by: (say)Modified PBT

Therefore i should select Modified PBT from my database amongst other tables.

Is there a way to do so?Please assist me. thanks.

[leeny]

i jus realised wat i stupid question i've posted. sorry

[lmf232s]

leeny there is not such thing as a stupid question.
But i assume from your last post that you have this taken
care of?

[Bullschmidt]

And don't know if this might still be of interest at all (although it does NOT touch on the idea of a union query for multiple tables):

Classic ASP Design Tips - Search Criteria on Multiple Fields
http://www.bullschmidt.com/devtip-searchcriteria.asp