|
I would suggest setting the initial values into hidden variables.
Then when you receive the submit from the form, you can check which values have
changed and build the SQL query string accordingly.
(*Chris*)
----- Original Message -----
Sent: Thursday, July 22, 1999 7:05
AM
Subject: Runtime Query
I have around 5 comboboxes.The user has option of
selecting the comboboxes in all combinations and permutations.I fire a
database query with parameters that the user selects in the given
comboboxes.
So if the user selects values from all the
comboboxes then in my select statement I will have five parameters in the
where clause. If the user selects four the four parameters in the where
clause.
So in all it turns out to be 5* 4 * 3 * 2 * 1
combinations.
How should I handle this situation.I am using
Oracle as my Database Server.
thanks in Advance
Nimesh Kenia
|
