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]>
