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

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

Thx for your answer david !

Thats just what i thought so i did try

<sql:insert connection="$connection" table="{concat($art,'_',$gericht)}">
(with '{}')

But it dind4t help :(

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:56
An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Betreff: Re: AW: [xsl] conditional <sql:column> ?!


this is of course a question about thi ssaxon-specific extension rather than
xslt, but guessing...


 SXSQ0004: SQL INSERT failed: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object  name '{concat($art,'_',$gericht)}'


that looks like the SQL engine got passed the xpath expression rather than the
result of evaluating the expression.

should the attributes be attribute-value-templates, that is surrounded in
{...}? I'd guess so.

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.
________________________________________________________________________