cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Klaus Bertram" <bert...@n-bis.de>
Subject RE: programatically examine columns in a row
Date Mon, 17 Sep 2001 18:05:35 GMT
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:chris.newland@emorphia.com]
> Sent: Monday, September 17, 2001 8:43 PM
> To: cocoon-users@xml.apache.org
> 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 &lt; 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>

---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message