Subject: AW: [xsl] sql if exists From: "Szabo, Patrick \(LNG-VIE\)" <patrick.szabo@xxxxxxxxxxxxx> Date: Wed, 15 Apr 2009 10:22:45 +0200 |
Sorry but i donB4t really understand what you mean. Dou you mean... <xsl:choose> <xsl:when test="exists("SELECT STATEMENT")"> <...> </xsl:when> <xsl:otherwise> <...> </xsl:otherwise> </xsl:choose> ??? I think i didnB4t make myself clear. What i want to do: First i want to check if a certain row already exists in the DB. If that is not the case i want to insert that row. 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 Patrick Szabo XSLT-Entwickler Tel.: +43 (1) 534 52 - 1573 Fax: +43 (1) 534 52 - 146 Patrick.Szabo@xxxxxxxxxxxxx LexisNexis Verlag ARD Orac GmbH & Co KG Marxergasse 25, 1030 Wien FN 8333f, Handelsgericht Wien http://www.lexisnexis.at/ -----UrsprC<ngliche Nachricht----- Von: Michael Kay [mailto:mike@xxxxxxxxxxxx] Gesendet: Mittwoch, 15. April 2009 10:09 An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Betreff: RE: [xsl] sql if exists 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.szabo@xxxxxxxxxxxxx] > Sent: 15 April 2009 08:32 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: [xsl] sql if exists > > Hi, > > IB4m 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 thatB4d 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 iB4m 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.szabo@xxxxxxxxxxxxx > > 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.Szabo@xxxxxxxxxxxxx > > LexisNexis Verlag ARD Orac GmbH & Co KG > Marxergasse 25, 1030 Wien > FN 8333f, Handelsgericht Wien > http://www.lexisnexis.at/
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] sql if exists, Michael Kay | Thread | RE: [xsl] sql if exists, Michael Kay |
RE: [xsl] sql if exists, Michael Kay | Date | RE: [xsl] sql if exists, Michael Kay |
Month |