I use this...
http://jakarta.apache.org/taglibs/doc/standard-doc/intro.html
Peter Choe <[EMAIL PROTECTED]>
10/28/2003 08:26 AM
Please respond to "Tag Libraries Users List"
To: Tag Libraries Users List <[EMAIL PROTECTED]>
cc:
Subject: Re: dbtags - <sql:setColumn> question
i thought i was using the standard taglibrary. i downloaded the
jakarata-taglibs.zip and used the jakarta-dbtags.jar file.
is there another standard tag library that i should get? can you post
the link for it?
thanks
Peter
[EMAIL PROTECTED] wrote:
>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]
>
>
>
>
>
>
