I have quite a dilema going here... wondering if anyone has any insight.
I have a 2 page system which allows users to select from a series of drop down menus on one page, and based on their criteria, a SQL statement gets formed and run against a table. The results, based on their criteria are displayed on a second page.
The drop down's are auto populated based on database entries, and all drop downs are optional. The disadvantage I have is, this is running against an Oracle database... so the functionality is a bit more difficult. It's obviously the secondary page I'm having trouble with... how to allow all the criteria the user has given to bring back results, or if nothing is selected at all, it returns everything.
If someone can give me insight on a logical approach to this, I'd appreciate it.
