I'll upgrade both and let you know the outcome..... -----Original Message----- From: Shawn Bayern [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 1:54 PM To: Tag Libraries Users List Subject: RE: Multiple queries in one jsp
I hate to sound like a corporate customer-service representative, but it might be helpful to upgrade to the most recent version. I couldn't swear that we didn't have a bug causing SKIP_PAGE to be returned from doEndTag() back in March. (It seems vaguely familiar, but I don't have time to check the CVS archives.) -- Shawn Bayern "JSP Standard Tag Library" http://www.jstlbook.com (coming this summer from Manning Publications) On Fri, 17 May 2002, Zvolensky, Thomas J {PDBI~Nutley} wrote: > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
