Hi Klaus,
Sorry, I should have explained it better. I want to examine the column values
and only produce XML for column names that have a certain value.
Each row in my table has columns of type bool and I want to only display the
names of columns where the value is 1 (true).
Do you know of a way to do this?
Thanks,
Chris
On Monday 17 September 2001 18:05, Klaus Bertram wrote:
> 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]>
