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:whentest="/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[(_at_)typ='p']/ris:absatz),'Seite '), ' von ', '/'))"/>

</sql:insert>
</xsl:when>
<xsl:otherwise>
<sql:insert connection="$connection" table="concat($art,'_',$gericht)">

</sql:insert>
</xsl:otherwise>
</xsl:choose>


--

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

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--