I had the same problem - when there were 0 rows returned by the query.
I suggest you switch to the standard tag library - works much better.
Adrian Beech <[EMAIL PROTECTED]>
10/27/2003 06:33 PM
Please respond to "Tag Libraries Users List"
To: "'Tag Libraries Users List'" <[EMAIL PROTECTED]>
cc:
Subject: RE: dbtags - <sql:setColumn> question
G'day Peter & list,
I'm getting similar behavior with the SQL query string being included as
part of the HTML text even though the SQL statement is definitely
between <sql:query> and </sql:query> tags. I posted a question about
this last Sunday... alas though no response thus far from the list.
The behavior is inconsistent in that I can remove the apps working
directory (under work/standalone/localhost), restart Tomcat and in one
instance the SQL statement is not shown but repeating the process a
second or third time it will appear. However in all cases the SQL
statement will be included as part of the HTML when ever the page is
reloaded and an empty result set is returned. In my case I have an
overdue page which is refreshed every 3 minutes. This is how the
problem first came to light when the page refreshed after it's initial
load.
This doesn't exactly help you with your problem. Though it does
highlight that something astray is going on.
AB
-----Original Message-----
From: Peter Choe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 28 October 2003 6:11 AM
To: Tag Libraries Users List
Subject: Re: dbtags - <sql:setColumn> question
the problem seems to be that if i use the session.getAttribute("sid"),
it will display the value on the browser even though it is between the
<sql:setColumn position="2"> .
so, i am not sure if this is a bug anyone has encountered before or if i
am doing something wrong?
a little help here.
Peter Choe
Manos Papantoniou wrote:
>I am not an expert, but it could be that when you refresh the page, the
><%=request.getParameter("discipline")%> value is empty. Or it could be
>another variable that only has request-time life and not session-time
>life duration, so the contents of the variable are empty when the
>reload happens. Perhaps you want to experiment with changing some of
>your request.* methods to session.* if possible or at least inspecting
>their contents when you reload the page. Then again maybe somebody more
>experienced in this forum might have a better idea
>
>
>
> ----- Original Message -----
> From: Peter Choe
> To: [EMAIL PROTECTED]
> Sent: Monday, October 27, 2003 6:04 PM
> Subject: dbtags - <sql:setColumn> question
>
>
> i am using dbtags library in my jsp file.
>
> i have the following set up:
>
> <table border="1">
> <tr><th>Course</th><th>Days of Week</th><th>Time</th><td></td></tr>
> <sql:preparedStatement id="pstmt" conn="con">
> <sql:query>SELECT crs_id, discipline, course_num, days_of_week,
> time_slot FROM time_slots, wait_list_course WHERE
> time_slots.time_id=wait_list_course.t
> ime_id AND is_available='Yes' AND discipline=? AND
> wait_list_course.semester=?</sql:query>
> <sql:setColumn
> position="1"><%=request.getParameter("discipline")%></sql:setColumn>
> <sql:setColumn position="2"><%=semester%></sql:setColumn>
> <sql:resultSet id="rs">
> <tr><td>
> <sql:getColumn position="2" />
> <sql:getColumn position="3" /></td><td>
> <sql:getColumn position="4" /></td><td>
> <sql:getColumn position="5" /></td><td>
> <sql:preparedStatement id="pstmt2" conn="con">
> <sql:query>SELECT added, removed FROM student_status
WHERE
> crs_id=? AND student_id=? AND added is not null</sql:query>
> <sql:setColumn position="1"><sql:getColumn
position="1"
> /></sql:setColumn>
> <sql:setColumn
> position="2"><%=(String)session.getAttribute("sid")%></sql:setColumn>
> <sql:resultSet id="rs2">
> </sql:resultSet>
> <sql:wasEmpty><input type="button" name="add"
> value="Add Me" onClick="getOn('<sql:getColumn position="1" />',
> 'add')"></sql:wasEmpty>
> <sql:wasNotEmpty><b>Added</b></sql:wasNotEmpty>
> </sql:preparedStatement></td></tr>
> </sql:resultSet>
> <sql:wasNotEmpty />
> <sql:wasEmpty><tr><td
> colspan="4"><%=request.getParameter("discipline")%> currently has no
> courses available for wait list for <%=session.getAttribute(
> "semester")%> semester.</td></tr></sql:wasEmpty>
> </sql:preparedStatement>
> <tr><td colspan="4" align="center"><a
> href="/registrar_appt/waitlist/menu.jsp">Back to main
menu</a></td></tr>
> </table>
> </form>
> </center>
>
> when i run the page in the web browser the value of the
> <sql:setColumn
> position="2">
<%=(String)session.getAttribute("sid")%></sql:setColumn>
> is shown on the web browser. but this doesn't occur on a constant
> basis. if i refresh the page, the value is not shown. is the syntax
> correct or is there something i need to do to prevent the value from
> being processed by the web browser?
>
> Peter Choe
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
