w jednymxmlu jest pole files a w drogim nie ma, jak skostrułowac warunek?
chciałbym tu dopisac jakiegoś if, albo when tak zeby sprawdzić czy w danych xml jest pole files jesli nie ma to kod ma sie wykonać jesli jest to ma sie wykonać inny kod który obsługuje pole files
Kod
<xsl:for-each select="//NEWS/ROW">
<xsl:sort select="AKCJA" data-type="text"/>
<xsl:choose>
<xsl:when test="AKCJA='Dodaj'">
INSERT INTO news (nid,gid,grup,temat,skrot,news,dirname,files,fsize,dodany,wygasa,widoczny,kto
,export,deleted,wersja) VALUES (
'<xsl:value-of select="NID"/>','<xsl:value-of select="GID"/>','<xsl:value-of select="GRUP"/>','<xsl:value-of select="TEMAT"/>','<xsl:value-of select="SKROT"/>','<xsl:value-of select="NEWS"/>','<xsl:value-of select="DIRNAME"/>','<xsl:value-of select="DODANY"/>','<xsl:value-of select="WYGASA"/>','<xsl:value-of select="WIDOCZNY"/>','<xsl:value-of select="KTO"/>','<xsl:value-of select="EXPORT"/>','<xsl:value-of select="DELETED"/>','<xsl:value-of select="WERSJA"/>');
</xsl:when>
<xsl:when test="AKCJA='Popraw'">
UPDATE news SET temat='<xsl:value-of select="TEMAT"/>',skrot='<xsl:value-of select="SKROT"/>',news='<xsl:value-of select="NEWS"/>',dirname='<xsl:value-of select="DIRNAME"/>',dodany='<xsl:value-of select="DODANY"/>',wygasa='<xsl:value-of select="WYGASA"/>',widoczny='<xsl:value-of select="WIDOCZNY"/>',kto='<xsl:value-of select="KTO"/>',export='<xsl:value-of select="EXPORT"/>',deleted='<xsl:value-of select="DELETED"/>' WHERE grup='<xsl:value-of select="GRUP"/>' and wersja='<xsl:value-of select="WERSJA"/>';
</xsl:when>
</xsl:choose>
</xsl:for-each>
<xsl:sort select="AKCJA" data-type="text"/>
<xsl:choose>
<xsl:when test="AKCJA='Dodaj'">
INSERT INTO news (nid,gid,grup,temat,skrot,news,dirname,files,fsize,dodany,wygasa,widoczny,kto
,export,deleted,wersja) VALUES (
'<xsl:value-of select="NID"/>','<xsl:value-of select="GID"/>','<xsl:value-of select="GRUP"/>','<xsl:value-of select="TEMAT"/>','<xsl:value-of select="SKROT"/>','<xsl:value-of select="NEWS"/>','<xsl:value-of select="DIRNAME"/>','<xsl:value-of select="DODANY"/>','<xsl:value-of select="WYGASA"/>','<xsl:value-of select="WIDOCZNY"/>','<xsl:value-of select="KTO"/>','<xsl:value-of select="EXPORT"/>','<xsl:value-of select="DELETED"/>','<xsl:value-of select="WERSJA"/>');
</xsl:when>
<xsl:when test="AKCJA='Popraw'">
UPDATE news SET temat='<xsl:value-of select="TEMAT"/>',skrot='<xsl:value-of select="SKROT"/>',news='<xsl:value-of select="NEWS"/>',dirname='<xsl:value-of select="DIRNAME"/>',dodany='<xsl:value-of select="DODANY"/>',wygasa='<xsl:value-of select="WYGASA"/>',widoczny='<xsl:value-of select="WIDOCZNY"/>',kto='<xsl:value-of select="KTO"/>',export='<xsl:value-of select="EXPORT"/>',deleted='<xsl:value-of select="DELETED"/>' WHERE grup='<xsl:value-of select="GRUP"/>' and wersja='<xsl:value-of select="WERSJA"/>';
</xsl:when>
</xsl:choose>
</xsl:for-each>