cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Hübner" <sthueb...@googlemail.com>
Subject Re: SQLTransformer vs. column aliases
Date Thu, 22 Feb 2007 22:11:00 GMT
Thanks Tobia,

I'm working with MySQL too. Maybe I should have a look at their docu.

-Stefan

2007/2/22, Tobia <tobia.conforto@linux.it>:
> Stefan Hübner wrote:
> > Dev at weitling <dev@weitling.net>:
> > > select a.name as aName, a.id as aID, b.id as bID, b.name as bName
> >
> > no, disappointingly enough, that doesn't work.
>
> It works here, using MySQL.
> Maybe it depends on the SQL engine?
>
> If you can't get the "as" keyword to work, you can always use some XSLT
> to tell them apart or to rename them:
>
> <xsl:template match="sql:rowset/sql:row/sql:id[position() = 1]">
>
> <xsl:template match="sql:rowset/sql:row/sql:id[position() = 2]">
>
>
> Tobia
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
Mime
View raw message