On Friday 22 March 2002 11:15 am, you wrote:
> Hi Folks
>
> Assuming that I have something like this working,
> then I would like to know how I can get the column Names
> and use then in a <TH> and cycle through each row and
> print all the columns of each row as <TD>.
>
> How do I get access to the MetaData and use it
> to get the data I need.
>
<esql:get-column-name column="1"/>
should do it.
See also:
/documents/userdocs/xsp/esql.html
On your cocoon server or the cocoon site -- docs from cvs look to be more up
to date, though.
> Any help greatly appreciated.
> Regards
> Joseph Rajkumar
> ===========================================================
>
> <esql:query>SELECT * FROM products</esql:query>
> <esql:results>
> <table>
> <TR>
> I want to print each of the column names using
> the <TH> tag here, I do not know the number of
> columns, nor the column data type.
> </TR>
> <esql:row-results>
> <tr>
> <td>
> HERE I WANT TO print the column data basically
> a loop to print the data from each column in a row.
> </td>
> </tr>
> </esql:row-results>
> </table>
> </esql:results>
---------------------------------------------------------------------
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]>
