Hello everybody,

Im using DW8 | ASP and I'm trying to do what seems to be the impossible -- creating 3 dynamic dropdowns and using them as search parameters. The idea is to select values from each of the dropdowns and submit those values to do a search query. I've created a successful connection to my DB (MS Access), tried various RecordSets, the Master/Detail setup, tried populating a hidden table with the values selected but nothing I do seems to work. I would really appreciate any input anyone has to offer on this. Thank you!

That was something i wanted to do too, but instead I have to just use 1 drop down and then use that, I couldn't figure out how to filter results using more than 1 variable

Do n't worry it is just possible with dream weaver itself. Just go to help and try getting some help on Advanced search options.... You will be able to get the best stuff there itself on "Advanced recordset, Search with multiple parameters,etc."

You can use a simple logic of sending those three drop down menu items as three input items in a form & submit these values into an advanced recordset to return the results...You will also get information on making Advanced sql query....etc.

for More help:
Visit these links:

www.adobe.com/devnet/dreamweaver/articles/easy_sql.html
livedocs.adobe.com/dreamweaver/8/using/wwhelp/wwhimpl/common/html/wwhelp.htm?context=LiveDocs_Parts&file=35_con11.htm
livedocs.adobe.com/dreamweaver/8/using/wwhelp/wwhimpl/common/html/wwhelp.htm?context=LiveDocs_Parts&file=35_con11.htm
livedocs.adobe.com/dreamweaver/8/using/wwhelp/wwhimpl/common/html/wwhelp.htm?context=LiveDocs_Parts&file=35_con11.htm
livedocs.adobe.com/dreamweaver/8/using/wwhelp/wwhimpl/js/html/wwhelp.htm?href=35_con11.htm

Edited by - satheeshkd on 07 Jun 2007 09:35:22

Edited by - satheeshkd on 07 Jun 2007 09:40:48

U solved your problem?? im with the same problem here and dont know how to solve , please if u find a answer send me a email to