On Thursday, July 22, 1999 9:06 AM, Kenia Nimesh
[SMTP:[EMAIL PROTECTED]] wrote:
> 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
Why not build your select statement dynamically?
Bob
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
