On 20.Mar.2002 -- 01:21 PM, von Schwerdtner, Thomas (GXS, FPI) wrote: > test.xsp contains: > ======================================================================== > <xsp:page > xmlns:xsp="http://apache.org/xsp" > xmlns:xlink="http://www.w3.org/1999/xlink" > xmlns:esql="http://apache.org/cocoon/SQL/v2" > language="java"> > > <esql:connection> > <esql:pool>gesupply</esql:pool> > <esql:execute-query> > <esql:query>SELECT > Id,SupportClassId,Type,Description FROM supporttype<esql:results> > <table> > <esql:row-results> > <tr> > <td> > > <esql:get-string column="Id"/></td><td> > > <esql:get-string column="Type"/></td> > </tr> > </esql:row-results> > </table> > </esql:results> > <esql:no-results> > <p>Sorry, no results!</p> > </esql:no-results> > </esql:query> > </esql:execute-query> > </esql:connection> > </xsp:page>
This is wrong esql syntax. You need to end your query tag at the end of the query, it does not span the results. Try <esql:connection> <esql:pool>gesupply</esql:pool> <esql:execute-query> <esql:query>SELECT Id,SupportClassId,Type,Description FROM supporttype</esql:query> <esql:results> <table> <esql:row-results> <tr> <td><esql:get-string column="Id"/></td> <td><esql:get-string column="Type"/></td> </tr> </esql:row-results> </table> </esql:results> <esql:no-results> <p>Sorry, no results!</p> </esql:no-results> </esql:execute-query> </esql:connection> Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- 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]>