Hi,
I'm executing a query with JSTL and trying to assign resultset values to variables using the <c:set> tag like this:
The query (stored proc) executes correctly and I'm not having db connectivity problems with this app.
Any ideas?
Thanks in advance for any help!
-mD
I'm executing a query with JSTL and trying to assign resultset values to variables using the <c:set> tag like this:
Code:
<c:catch var="err1">
<sql:query dataSource="jdbc/asdf" scope="page" var="detail">
MonthlyProgressReport ${contractorID}, '${taskID}'
</sql:query>
</c:catch>
<c:forEach items="${detail.rows}" var="detailsout">
<c:set var="beg_date" value="${detailsout.PERIOD_OF_PERF_START}" />
<c:set var="end_date" value="${detailsout.PERIOD_OF_PERF_END}" scope="page" />
<c:set var="descr" value="${detailsout.DESCR}" scope="page" />
</c:forEach>
The query (stored proc) executes correctly and I'm not having db connectivity problems with this app.
Any ideas?
Thanks in advance for any help!
-mD