I'm using Tomcat 4.0.1 right now and will be moving to a BEA WebLogic server soon. I can't determine the version of the JSTL RI but the jstl.jar is dated 3/12/02.
-----Original Message----- From: Shawn Bayern [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 1:42 PM To: Tag Libraries Users List Subject: RE: Multiple queries in one jsp What version of JSTL are you using, and what container? It sounds like a very unusual problem -- potentially a container bug, or a bug from an old version of the JSTL RI. Shawn On Fri, 17 May 2002, Zvolensky, Thomas J {PDBI~Nutley} wrote: > 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. > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
