AW: [xsl] conditional <sql:column> ?!

["Szabo, Patrick (LNG-VIE)" <patrick.szabo@xxxxxxxxxxxxx>]

Okay, i4m 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.szabo@xxxxxxxxxxxxx

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@xxxxxxxxx]
Gesendet: Dienstag, 23. September 2008 14:15
An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
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.
________________________________________________________________________