You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Matthew Hailstone <ma...@waterford.org> on 2002/06/04 21:05:38 UTC
Showing Column names in XSP
I'm trying to get the column names of a particular query, but with no
luck so far. Here is a portion of my XSP source:
<esql:connection>
<esql:pool>wcart22</esql:pool>
<esql:execute-query>
<esql:query>select * from classes</esql:query>
<esql:results>
<xsp:logic>
for(int i=0; i < <esql:get-metadata/>.getColumnCount();
i++)
{
<field><xsp:expr><esql:get-metadata/>.getColumnName(i)</xsp:expr></field
>
}
</xsp:logic>
<esql:row-results>
<para>
<esql:get-columns/>
</para>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
The above produces nothing.
The following source:
<esql:connection>
<esql:pool>wcart22</esql:pool>
<esql:execute-query>
<esql:query>select * from classes</esql:query>
<esql:results>
<esql:row-results>
<para>
<esql:get-columns/>
</para>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
produces the column name as an element and its respective value. (as
expected)
Any help would be greatly appreciated. Thanks.
Matthew
Re: Showing Column names in XSP
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 04.Jun.2002 -- 01:05 PM, Matthew Hailstone wrote:
> I'm trying to get the column names of a particular query, but with no
> luck so far. Here is a portion of my XSP source:
>
> <esql:connection>
> <esql:pool>wcart22</esql:pool>
> <esql:execute-query>
> <esql:query>select * from classes</esql:query>
>
> <esql:results>
> <xsp:logic>
for(int i=0; i < <esql:get-column-count/>; i++)
> {
> <field><xsp:expr><esql:get-metadata/>.getColumnName(i)</xsp:expr></field>
<!-- the above could use <esql:get-column-name/> if it were placed in row-results -->
> }
> </xsp:logic>
> <esql:row-results>
> <para>
> <esql:get-columns/>
> </para>
> </esql:row-results>
> </esql:results>
> </esql:execute-query>
> </esql:connection>
>
> The above produces nothing.
For me it translates to the correct java code. Please have a look at
the generated java source and check the logs.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>