By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,867 Members | 1,964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,867 IT Pros & Developers. It's quick & easy.

Multiple filter using ASP,ADODB

P: 1
I have to designe a web page using ASP & ODBC data connectivity to show extract data from Access table to show data in tabular form.
I have to filter data based on 5 critaria
1. Display all records by selecting ALL for all 5 fields.
2. Display records by selecting some fields as ALL and other fields with options selected from drop down menu.

eg.
Field1 Field2 Field3 Field4 Field5 Search Button

Drop down list for all fields with one option as "ALL"

I have already created the page but I am unable to prepare SQL statement for filtering data with different option

Need Help.
Nov 22 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.