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?

Reply via email to