Sure. You can do it at the XSLT level
<xsl:choose>
<xsl:when test="exists(/a/b/c)">
<...>
</xsl:when>
<xsl:otherwise>
<...>
</xsl:otherwise>
</xsl:choose>
or at the XPath level:
select="if (exists(/a/b/c)) then ... else ..."
In practice people often leave out the call to exists() because the
effective boolean value of a node-sequence is true if it's non-empty, so
this is equivalent to test="/a/b/c".
Michael Kay
http://www.saxonica.com/
-----Original Message-----
From: Szabo, Patrick (LNG-VIE)
[mailto:patrick(_dot_)szabo(_at_)lexisnexis(_dot_)at]
Sent: 15 April 2009 08:32
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] sql if exists
Hi,
I´m using saxon 9 and xslt 2.
I want to insert data into a database with my xslt-sheet
which is no problem. The problem is that i only want to do
that under certain conditions.
In SQL that´d look like this:
"IF EXISTS ( select * from...)
Do something
ELSE
do something else"
Is there a way to use that code in my xslt-sheet ?!
Currently i´m using
"java:/net.sf.saxon.sql.SQLElementFactory" to insert
something at all.
Thx already
cheers
Patrick Szabo
EPD / XSLT Konvertierung
Tel.: +43-1-534 52-1573
Fax.: +43-1-534 52-1573
patrick(_dot_)szabo(_at_)lexisnexis(_dot_)at
LexisNexis Verlag ARD Orac GmbH & Co KG
Marxergasse 25, 1030 Wien
FN 8333f, Handelsgericht Wien
www.lexisnexis.at <http://www.lexisnexis.at/>
<file://C:\Dokumente und
Einstellungen\szaboP\Anwendungsdaten\Microsoft\Signatures\LN
Vienna signature-Dateien\image001.jpg>
Patrick Szabo
XSLT-Entwickler
Tel.: +43 (1) 534 52 - 1573
Fax: +43 (1) 534 52 - 146
Patrick(_dot_)Szabo(_at_)lexisnexis(_dot_)at
LexisNexis Verlag ARD Orac GmbH & Co KG
Marxergasse 25, 1030 Wien
FN 8333f, Handelsgericht Wien
http://www.lexisnexis.at/
--~------------------------------------------------------------------
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>
--~--
--~------------------------------------------------------------------
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>
--~--