Okay, i´m using your statement now, but now there is another problem:
I get the following error:
SXSQ0004: SQL INSERT failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object
name '{concat($art,'_',$gericht)}'
The error points to this statement:
<sql:insert connection="$connection" table="concat($art,'_',$gericht)">
....
The value of concat($art,'_',$gericht), seems to be alright and if i set a
static value for table everything works fine though the value that i input
staticly and the value of concat($art,'_',$gericht) are the same.
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
-----Ursprüngliche Nachricht-----
Von: David Carlisle [mailto:davidc(_at_)nag(_dot_)co(_dot_)uk]
Gesendet: Dienstag, 23. September 2008 14:15
An: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Betreff: Re: [xsl] conditional <sql:column> ?!
I guess in that case you have to use
<xsl:choose>
<xsl:when
which would look a bit less scary if you did
<xsl:for-each
select="/ris:result/ris:data/ris:risdokument/ris:metadaten">
<xsl:choose>
<xsl:when test="ris:technisch/ris:organ='OGH' and
ris:judikatur/ris:doktyp='T'"> <sql:column name="DOKNR"
select="normalize-space(replace(ris:technisch/ris:id,'_','/'))"/>
<sql:column name="Datum"
select="normalize-space(replace(ris:judikatur/ris:datum, '-', ''))"/> ...
David
________________________________________________________________________
The Numerical Algorithms Group Ltd is a company registered in England and Wales
with company number 1249803. The registered office is:
Wilkinson House, Jordan Hill Road, Oxford OX2 8DR, United Kingdom.
This e-mail has been scanned for all viruses by Star. The service is powered by
MessageLabs.
________________________________________________________________________
--~------------------------------------------------------------------
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>
--~--