Squeling for SQL help

[badlad]

I have a form with 1 textbox (txtSearch) and a 1dropdown (dropdown), the textbox is the search string and the dropdown is a list/menu of which the values=the 3 columns in the Access database.

the form is set to GET and the correct asp file is set as results.

My knowledge of SQL is still in it's infancy, so any help would be much appreciated.

I know that the initial sql statement is:-

SELECT *
FROM tablename
WHERE .............

Can anyone fill in the blanks, to complete the sql statement in advanced.

failing that a similar sql statement that uses 1 textbox and searches 3 columns in 1 table.

I am happy at simple searches and filtering and sorting 1 column.

Pete Heseltine

The Heseltine Network.

http://www.heseltine.net

mailtoeter.heseltine@heseltine.net

 

[Jayuk]

If you go to HELP on Ultradev and search for "Searching with Multiple Search Parameters" this should solve your query regarding having one search field that searches all fields/columns.

j ;-)

 

[mlawson]

Peter,

Drop me a note as I have a three line script that in turn searches the dropdown with or without the textbox based on the value selected. ULtradev, wasn't it 'spposed to make it easier? M

 

[badlad]

Dear M Lawson,

Ultradev is quite a powerful tool, but a greater one is a bumper book of SQL!

drop us an e' for further info

thanks matey.