468,550 Members | 2,424 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

Multiple filter using ASP,ADODB

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
0 1504

Post your reply

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

Similar topics

reply views Thread by Channing Jones | last post: by
reply views Thread by Hemanth | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.