> > <page>
> > <esql:connection>
> > <esql:pool>my_pool</esql:pool>
> > <esql:execute-query>
> > <esql:query>select name, number
> > from employee
> > </esql:query>
> > <esql:results>
> > <header>
> > <name>EmpName</name>
> > <number>EmpNumber</number>
> > </header>
> > <esql:row-results>
> > <first-level>
> > <esql:get-columns/>
> > </first-level>
> > </esql:row-results>
> > <esql:no-results>
> > <user>no Values available</user>
> > </esql:no-results>
> > <footer>copyright</footer>
> > </esql:results>
> > </esql:execute-query>
> > </esql:connection>
> >
> > </page>
> >
> > </xsp:page>
>
> Looks ok...
Ah.. missed it! Your no-results is under results that's wrong!
You probably want something like this:
> > <page>
> > <esql:connection>
> > <esql:pool>my_pool</esql:pool>
> > <esql:execute-query>
> > <esql:query>select name, number
> > from employee
> > </esql:query>
<header>
<name>EmpName</name>
<number>EmpNumber</number>
</header>
> > <esql:results>
> > <esql:row-results>
> > <first-level>
> > <esql:get-columns/>
> > </first-level>
> > </esql:row-results>
</esql:results>
> > <esql:no-results>
> > <user>no Values available</user>
> > </esql:no-results>
> > <footer>copyright</footer>
> > </esql:execute-query>
> > </esql:connection>
--
Torsten
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
