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

Subject: RE: AW: [xsl] conditional <sql:column> ?!
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Tue, 23 Sep 2008 23:07:36 +0100
As pointed out on the Saxon list, the table attribute is not an AVT. Don't
know why, except that the SQL extension in Saxon is all user-supplied code
contributed by a number of people over a period of some years, and was never
really designed as a coherent whole.

Michael Kay
http://www.saxonica.com/

> -----Original Message-----
> From: Szabo, Patrick (LNG-VIE) [mailto:patrick.szabo@xxxxxxxxxxxxx]
> Sent: 23 September 2008 14:07
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: AW: AW: [xsl] conditional <sql:column> ?!
>
> 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.
> ______________________________________________________________
> __________

Current Thread