I have a form page that I would like to populate several drop-downs with
values in a database table. It works fine with one query for the first
element. When I add the second query to the code, the page comes up as a
blank.
Here is my query code:
<sql:driver
var="example"
driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@nuoradcm.tot.roche.com:1537:rapiddcm"
/>
<sql:query var="docbase" dataSource="${example}">
select distinct DOCBASE from Authentications order by DOCBASE
</sql:query>
<sql:query var="site" dataSource="${example}">
select distinct CITY from Authentications order by CITY
</sql:query>
Is it possible to perform multiple queries in the same page?