Subject: [xsl] conditional <sql:column> ?! From: "Szabo, Patrick (LNG-VIE)" <patrick.szabo@xxxxxxxxxxxxx> Date: Tue, 23 Sep 2008 12:17:39 +0200 |
Hi, I4m using xslt 2.0 and saxon 9 What i want to do is insert data into a database (which works already), but 1 column should not always be inserted. This is what i have right now: <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]))"/> <xsl:if 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: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 ', '/'))"/> </xsl:if> </sql:insert> 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 ?! Thanks already ! regards
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Self-analysing stylesheet, Michael Ludwig | Thread | Re: [xsl] conditional <sql:column> , Martin Honnen |
Re: [xsl] Self-analysing stylesheet, G. Ken Holman | Date | Re: [xsl] conditional <sql:column> , Martin Honnen |
Month |