Re: VWP - dropDown bound to DB question

May I ask an additional question?
My situation is similar but a bit more elaborate. What I have is a number of
drop down lists which will filter out data in the table as user
selects the options.
By default I want to show all data from the SQL query in the DB table, however
once user selects one of the options I would like to update the table with only
data containing chosen data. Once he selects another drop down option, I want
to combine that one together with previously chosen, so forth... I wonder what
are the possible approaches to this problem?

First, I have thought of parametrized queries (to Derby DB for now), however,
this does not work for me since I have to immediately provide some default
parameters as it does not look like I can say something like:
"WHERE t."Name" = '*' " so that it would ignore the filter all
together, and show
all data from the query without WHERE. It seems, it not possible to
have a number
of parameters in SQL query that will be ignored if desired.