you *might* get away with doing something with the <nested> tags...
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:40
AM
Please respond to
"Tag Libraries
Users List"
no error is being reported but the jsp doesn't finish rendering. but i
guess i should redo the design. i was just trying to be lazy and avoid
coding.
thanks all.
Kris Schneider wrote:
>You're not really embedding one <sql:query> within another, but it should
work.
>What type of error(s) are you getting?
>
>Quoting Peter Choe <[EMAIL PROTECTED]>:
>
>
>
>>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>
>>
>>
>
>
>
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]
