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

["Szabo, Patrick (LNG-VIE)" <patrick.szabo@xxxxxxxxxxxxx>]

Thx, thats me being stupid again -.-

cheers

Patrick Szabo
EPD / XSLT Konvertierung
Tel.: +43-1-534 52-1573
Fax.: +43-1-534 52-1573
patrick.szabo@xxxxxxxxxxxxx

LexisNexis Verlag ARD Orac GmbH & Co KG
Marxergasse 25, 1030 Wien
FN 8333f, Handelsgericht Wien
www.lexisnexis.at





-----Urspr|ngliche Nachricht-----
Von: Martin Honnen [mailto:Martin.Honnen@xxxxxx]
Gesendet: Dienstag, 23. September 2008 14:04
An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Betreff: Re: [xsl] conditional <sql:column> ?!

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:or
gan/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:meta
daten/ris:technisch/ris:id,'_','/'))"/>
<sql:column name="Datum"
select="normalize-space(replace(/ris:result/ris:data/ris:risdokument/ris:meta
daten/ris:judikatur/ris:datum,
'-', ''))"/>
<sql:column name="Filename"
select="normalize-space(concat(/ris:result/ris:data/ris:risdokument/ris:metad
aten/ris:technisch/ris:id/text(),
'.xml'))"/>
<sql:column name="Gesnr"
select="normalize-space(string(/ris:result/ris:data/ris:risdokument/ris:metad
aten/ris:judikatur/ris:gz/child::*[$count]))"/>
<sql:column name="SZ" select="concat('SZ
',replace(substring-after(normalize-space(/ris:result/ris:data/ris:risdokumen
t/ris:dokumentliste/ris:hauptdokument/ris:inhalt/ris:daten/ris:xml/ris:nutzda
ten/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:meta
daten/ris:technisch/ris:id,'_','/'))"/>
<sql:column name="Datum"
select="normalize-space(replace(/ris:result/ris:data/ris:risdokument/ris:meta
daten/ris:judikatur/ris:datum,
'-', ''))"/>
<sql:column name="Filename"
select="normalize-space(concat(/ris:result/ris:data/ris:risdokument/ris:metad
aten/ris:technisch/ris:id/text(),
'.xml'))"/>
<sql:column name="Gesnr"
select="normalize-space(string(/ris:result/ris:data/ris:risdokument/ris:metad
aten/ris:judikatur/ris:gz/child::*[$count]))"/>
</sql:insert>
</xsl:otherwise>
</xsl:choose>


--

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