programatically examine columns in a row

[Chris Newland]

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 &lt; cols; i++)
                        {
                                colname = <esql:get-column-name><xsp:attribute 
name="column"><xsp:expr>i</xsp:expr></xsp:attribute></esql:get-column-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]>