Subject: AW: [xsl] conditional <sql:column> ?! From: "Szabo, Patrick (LNG-VIE)" <patrick.szabo@xxxxxxxxxxxxx> Date: Tue, 23 Sep 2008 14:15:51 +0200 |
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/
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: AW: [xsl] conditional <sql:colu, Michael Kay | Thread | [xsl] Custom function in template m, Ian Stokes-Rees |
Re: [xsl] conditional <sql:column> , David Carlisle | Date | AW: [xsl] conditional <sql:column> , Szabo, Patrick (LNG- |
Month |