Sorry,
I guess I assumed you were using Struts.
Never-the-less that work is better done in a servlet. Then all the page
has to do is iterate your resultset.
Savan Thongvanh
Berkley Technology Services
515.278.7725
Peter Choe
<[EMAIL PROTECTED] To: Tag Libraries Users List
<[EMAIL PROTECTED]>
ing.com> cc:
Subject: Re: embedding <sql:query>
11/10/2003 09:29
AM
Please respond to
"Tag Libraries
Users List"
i am relatively new to using the jstl. what do you mean putting it in
Action?
[EMAIL PROTECTED] wrote:
>
>
>
>Did you know you could get much better performance out of putting that sql
>stuff in the Action?
>Savan Thongvanh
>Berkley Technology Services
>515.278.7725
>
>
>
> Peter Choe
> <[EMAIL PROTECTED] To: Tag Libraries
Users List <[EMAIL PROTECTED]>
> ing.com> cc:
> Subject: embedding
<sql:query>
> 11/10/2003 09:25
> AM
> Please respond to
> "Tag Libraries
> Users List"
>
>
>
>
>
>
>is it possible to embed a <sql:query> tag inside a <sql:query>?
>
>i am trying to use the result of one sql to look up data with another sql:
>
><sql:query var="waitList" sql="SELECT discipline, course_num,
>days_of_week, time_slot, crs_id, is_available, wait_list_course.semester
>FROM wait_list_course, time_slots WHERE
>time_slots.time_id=wait_list_course.time_id AND school_id=? ORDER BY
>discipline, course_num, time_slot, is_available">
><sql:param value="${sessionScope.school}" />
></sql:query>
><c:forEach var="listRec" items="${waitList.rows}">
><tr><td><c:out value="${listRec.discipline}" /> <c:out
>value="${listRec.course_num}" /></td><td><c:out
>value="${listRec.days_of_week}" /></td><td><c:out
>value="${listRec.time_slot}" /></td><td><c:out
>value="${listRec.is_available}" /></td><td><c:out
>value="${listRec.semester}" /></td>
><sql:query var="count" sql="SELECT count(*) FROM student_status WHERE
>add IS NOT NULL AND crs_id=?">
><sql:param value="${listRec.crs_id}" />
></sql:query>
><td><c:forEach var="act_count" items="${count.rowsByIndex}"><c:out
>value="${act_count[0]}" /></c:forEach></td>
><td><input type="button" name="close" value="Close"
>onClick="doAction('<c:out value="${listRec.crs_id}" />', 'close',
>'No')"><input type="button" name="open" value="Open"
>onClick="doAction('<c:out value="${listRec.crs_id}" />', 'close',
>'Yes')"><input type="button" name="recycle" value="Recycle"
>onClick="doAction('<c:out value="${listRec.crs_id}" />', 'recycle')"></tr>
></c:forEach>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
>
>CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain
>private, privileged and confidential information belonging to the sender.
>The information therein is solely for the use of the addressee. If your
>receipt of this transmission has occurred as the result of an error,
please
>immediately notify us so we can arrange for the return of the documents.
>In such circumstances, you are advised that you may not disclose, copy,
>distribute or take any other action in reliance on the information
>transmitted.
>
>
>
>---------------------------------------------------------------------
>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]
CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain
private, privileged and confidential information belonging to the sender.
The information therein is solely for the use of the addressee. If your
receipt of this transmission has occurred as the result of an error, please
immediately notify us so we can arrange for the return of the documents.
In such circumstances, you are advised that you may not disclose, copy,
distribute or take any other action in reliance on the information
transmitted.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
