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]>
