Querying a database

[Guest]

I have looked at article 278613 - How to Query a Database by Using Multiple
Criteria with a Drop-Down Menu. I can get this to work with only using
drop-down menus in my search form, but I would like to be able to have a
search form with text boxes and drop-down menus. i.e. A name could be typed
in and a drop down menu used to select city.

Please help!

 

[Dan Abrey]

I have looked at article 278613 - How to Query a Database by Using Multiple
Criteria with a Drop-Down Menu. I can get this to work with only using
drop-down menus in my search form, but I would like to be able to have a
search form with text boxes and drop-down menus. i.e. A name could be typed
in and a drop down menu used to select city.

Without too much knowledge on Frontpage, I would say just use a normal
static <input> textbox, call it 'name', and then query your database for all
city names and IDs (assuming that's how it's set up). Depending on the
language you're using, then use a loop or output statement to dynamically
display the options in the <select> dropdown, call it 'city'.

Then use a SQL statement on the restults page to search the db for the name
and city ID.

Not sure if thats what you're looking for, but hope it helps anyway..

 

[Guest]

Thanks, for your help, but I'm afraid that was a little over my head.