The code below is just a piece of the page containing the query in the <head> section. Here's the whole thing:
---------------------------------------------------------------------------- -------------- <%@ page import="java.text.*, java.util.*" %> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/ea/core"; %> <%@ taglib prefix="sql" uri="http://java.sun.com/jstl/ea/sql"; %> <html> <head> <style> a{font-family:verdana; font-size:8pt; color:blue; text-decoration:none; font-weight:bold;} a:hover{color:red; text-decoration:underline;} td{font-family:verdana; font-size:10pt; } </style> <title>Docbase Authentications By Department Report</title> <%@ include file="DateFormat.js" %> <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> </head> <body onLoad="document.Criteria.after.focus()"> <center> <form name="Criteria" action="Query1_Ora.jsp" method=Post > <h1>Authentications by Department Report</h1><br> <h2>Criteria</h2> <table border="1" cellspacing="1" cellpadding="2"> <tr> <td width="100" bgcolor="#CCCCCC" colspan="2"><b>Docbase:</b></td> <! -- generate drop-down containing list of docbases --> <td > <select name="docbase"> <c:forEach var="row" items="${docbase.rows}"> <option value="<c:out value="${row.DOCBASE}"/>"><c:out value="${row.DOCBASE}"/> </c:forEach> </select> </td> </tr> <tr> <td bgcolor="#CCCCCC" rowspan="2"><b>Access Date:</b></td> <td bgcolor="#CCCCCC">on or after</td> <td><input type="text" name="after" size="10" maxlength="10" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')" value=""> mm/dd/yyyy Format </td> </tr> <tr> <td bgcolor="#CCCCCC">on or before</td> <td><input type="text" name="before" size="10" maxlength="10" onFocus="javascript:vDateType='1'" onKeyUp="DateFormat(this,this.value,event,false,'1')" onBlur="DateFormat(this,this.value,event,true,'1')" value=""> mm/dd/yyyy Format </td> </td> </tr> <tr> <td bgcolor="#CCCCCC" colspan="2"><b>Site:</b></td> <td><input type="text" name="site"></td> </tr> </table> <br> <center> <input type="submit" value="Run Report"> <input type="reset" value="Clear" name="clear"> <button type="button" name="Cancel" onclick="javascript:history.go(-1)">Cancel</button> </center> </form> </center> </body> </html> ---------------------------------------------------------------------------- ---------------- When I attempt to open the page it's completely blank. When I view the source of the blank page, the <head> section is incomplete and the remainder of the page is missing. If I remove the tags for the 2nd query, the page displays correctly. The same happens if I move the two query tags to the <body> section of the page. This is not making sense. -----Original Message----- From: Shawn Bayern [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:38 AM To: Tag Libraries Users List Subject: Re: Multiple queries in one jsp On Fri, 17 May 2002, Zvolensky, Thomas J {PDBI~Nutley} wrote: > 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. There shouldn't be any problem with what you're tring to do. What do you mean by "the page comes up as a blank"? The code you've shown won't print anything, so the problem most likely involves the way you're trying to print the results. After code like this: > <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> ... you could try to inspect the 'docbase' and 'site' variables manually to ensure they contain the data you expect. -- Shawn Bayern "JSP Standard Tag Library" http://www.jstlbook.com (coming this summer from Manning Publications) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
