xsl-list
[Top] [All Lists]

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

2008-09-23 18:08:56
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(_dot_)szabo(_at_)lexisnexis(_dot_)at] 
Sent: 23 September 2008 14:07
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
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 dind´t help :(

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:56
An: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
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. 
______________________________________________________________
__________

--~------------------------------------------------------------------
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>
--~--



--~------------------------------------------------------------------
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>
--~--

<Prev in Thread] Current Thread [Next in Thread>