Hi Chris,
try it with <esql:get-columns/>
like these
<esql:row-results>
<esql:get-columns/>
</esql:row-results>
the result in xsp is like these:
<colname1>value</colname1><colname2>value</colname2>...
at your xsl you can separate it for colname and value
Klaus
> -----Original Message-----
> From: Chris Newland [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 8:43 PM
> To: [EMAIL PROTECTED]
> Subject: programatically examine columns in a row
>
>
> Hi All,
>
> I'm looking for a generic way to examine the columns in a row
> retrieved using esql:
>
> <esql:results>
> <xsp:logic>
> int cols = <esql:get-column-count/>;
> String colname;
> </xsp:logic>
>
> <esql:row-results>
> <xsp:logic>
> for (int i = 0; i < cols; i++)
> {
> colname =
> <esql:get-column-name><xsp:attribute
> name="column"><xsp:expr>i</xsp:expr></xsp:attribute></esql:get-col
> umn-name>;
>
> }
> </xsp:logic>
> </esql:row-results>
> </esql:results>
>
> but this throws an exception: No method matching getColumnName()
> found in interface java.sql.ResultSetMetaData. (i.e. the column
> attribute is not being picked up)
>
> Is it possible to add attributes to a logicsheet tag? I don't
> think it is but I can't think of another way of passing the
> parameter to the get-column-name tag.
>
> Is this possible?
>
> Thanks,
>
> Best Regards,
>
> Chris
>
>
> ---------------------------------------------------------------------
> 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]>
---------------------------------------------------------------------
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]>
