how do i get a resultSet from the database using jstl <sql> tag the query is to get state,location,sublocations in a table and put them in their respective dropdown list on selecting the state the locations are to be shown related to that state in dropdown and selecting the lcoations the sublocations are to be shown related to that location in dropdown the catch is that i need to acces the database just once and i need to show only distinct states in the dropdown
