Hi,
I am trying to implement in JSP a nested JDBC query, to produce output like
the following -:
---------------------------------------------------
* Result 1 from Query 1
- Release 1 from Query 2(using Query 1, Result 1 input)
- Release 2 from Query 2(using Query 1, Result 1 input)
- Release 3 from Query 2(using Query 1, Result 1 input)
* Result 2 from Query 1
- Release 1 from Query 2(using Query 1, Result 2 input)
- Release 2 from Query 2(using Query 1, Result 2 input)
- Release 3 from Query 2(using Query 1, Result 2 input)
* Result 3 from Query 1
- Release 1 from Query 2(using Query 1, Result 3 input)
- Release 2 from Query 2(using Query 1, Result 3 input)
- Release 3 from Query 2(using Query 1, Result 3 input)
---------------------------------------------------
I was hoping to use DBTags and have nested <sql:resultSet> (ie 2 levels,
outer and inner loop) however this does not seem to work, as no output past
"Result 2" above occurs.
Q1 - Does anyone know whether there is a way to have nested DBTags in JSP
pages?
Q2 - If the answer is no, what would be the next easiest approach to getting
the output I want in JSP? I was hoping to do as much as possible in JSP (cf
scriptlets / beans).....well at least keep HTML output format in JSP (cf
having "out.println" statements in java code).
Note - I tried using <jsp:include ...> within the main DBTag loop to
reference a second JSP page with the inner loop in this, however I get an
error indicating that one can not use <jsp:include ...> within a customer
tag.
Thanks in advance
Greg
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
