Re: [xsl] conditional <sql:column> ?!

Subject: Re: [xsl] conditional <sql:column> ?!
From: Martin Honnen <Martin.Honnen@xxxxxx>
Date: Tue, 23 Sep 2008 14:04:17 +0200
Szabo, Patrick (LNG-VIE) wrote:

This does not work because there is no xsl:if allowed in sql:insert and no sql:column in xsl:if.
How can i accomplish a conditional sql:column ?!

I guess in that case you have to use
<xsl:choose>
<xsl:when test="/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:technisch/ris:organ/text()='OGH' and /ris:result/ris:data/ris:risdokument/ris:metadaten/ris:judikatur/ris:doktyp='T'">
<sql:insert connection="$connection" table="concat($art,'_',$gericht)">
<sql:column name="DOKNR" select="normalize-space(replace(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:technisch/ris:id,'_','/'))"/>
<sql:column name="Datum" select="normalize-space(replace(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:judikatur/ris:datum, '-', ''))"/>
<sql:column name="Filename" select="normalize-space(concat(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:technisch/ris:id/text(), '.xml'))"/>
<sql:column name="Gesnr" select="normalize-space(string(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:judikatur/ris:gz/child::*[$count]))"/>
<sql:column name="SZ" select="concat('SZ ',replace(substring-after(normalize-space(/ris:result/ris:data/ris:risdokument/ris:dokumentliste/ris:hauptdokument/ris:inhalt/ris:daten/ris:xml/ris:nutzdaten/ris:abschnitt[1]/ris:fzinhalt[@typ='p']/ris:absatz), 'Seite '), ' von ', '/'))"/>
</sql:insert>
</xsl:when>
<xsl:otherwise>
<sql:insert connection="$connection" table="concat($art,'_',$gericht)">
<sql:column name="DOKNR" select="normalize-space(replace(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:technisch/ris:id,'_','/'))"/>
<sql:column name="Datum" select="normalize-space(replace(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:judikatur/ris:datum, '-', ''))"/>
<sql:column name="Filename" select="normalize-space(concat(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:technisch/ris:id/text(), '.xml'))"/>
<sql:column name="Gesnr" select="normalize-space(string(/ris:result/ris:data/ris:risdokument/ris:metadaten/ris:judikatur/ris:gz/child::*[$count]))"/>
</sql:insert>
</xsl:otherwise>
</xsl:choose>



--


	Martin Honnen
	http://JavaScript.FAQTs.com/

Current Thread