Hi Michael,
you can also use in your database xsp
<row>
<esql:get-columns/>
</row>
this get all columns like
<row><ID>1234</ID>... </row>
and in your xsl
<xsl:template match="row">
<xsl:if test="position()=2">
<tr bgcolor="#eeeeee">
<xsl:for-each select="*"><td><xsl:value-of select="local-name(.)"/></td>
</xsl:for-each>
</tr>
</xsl:if>
<tr><xsl:for-each select="*"><td><xsl:value-of
select="."/></td></xsl:for-each></tr>
</xsl:template>
It works but, i didn't know why the first pos of row is empty
i try this with xml:sql and it works from the first pos nicely
I hope that help's a litle bit
Klaus
nbis - Rottgerweg 10 - 51371 Leverkusen
phone: +49-214-206494-0
fax: +49-214-206494-44
email: [EMAIL PROTECTED]
> -----Original Message-----
> From: Enke Michael [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 04, 2001 9:30 AM
> To: [EMAIL PROTECTED]
> Subject: esql-patch: tag-name
>
>
> Hi.
> I had the problem that I have to receive rows from a table
> where the number of columns is variable (because the query is
> variabe). For this reason it is useful to have the element names
> the same for each column.
> I introduced the "tag-name" attribute in esql:get-columns.
>
> E.g. <esql:get-columns tag-name="column"/> will result in
> <column>
> col1
> </column>
> <column>
> col2
> </column>
> ...
>
> ( Remark: the tag-case applies after this too.
> <esql:get-columns tag-name="column" tag-case="upper"/>
> results in <COLUMN>col1</COLUMN>... )
>
> Could a commiter commit this please?
> One question: If I get the dev-snapshot, which version do I get?
> 2.0 or 2.1?
>
> Regards,
> Michael
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
