mulitple select from drop down list
Posted on 2003-02-28
Hi have a drop down list of account codes & account description like:
<select name="acc" size=5 multiple>
<option value="1">acct1 desc</option>
<option value="2">acct2 desc</option>
<option value="3">acct3 desc</option>
<option value="n">acctn desc</option>
so every thing work's fine like if user select's 3 accounts on the screen from DD list my bean will get 3 account codes for the query and i getting them in a array
and framing the query like account IN(1, 2, 3)
so if one account code is selected or more selected it works fine retrieves aqurate results.
But when user selects ALL i want to pass all the account codes from the DD list to the Bean like:
Bean Query should look like this
account IN (1,2,3,..............n) what ever is there in the Drop down list all codes should be passed to the Bean.
Any ideas , greatly appreciated.