Hi,

I have been trying very hard to make this statement work -

<xsl:value-of select="INSERT INTO Table1 VALUES("$a","$b")"/>

where $a and $b are two variables.

I get a syntax error

"Expected end of the expression, found INTO. INSERT <--- INTO ---> Table1 VALUES..."

Any help would be appreciated. This is the first time I am trying to insert two simple values into a table.

Thanking you,

Warm regards,
Sekhar

Firstly, it's not valid XML. An attribute using double-quotes as its delimiters can't contain a double-quotes character within the value.

Secondly, if you fix this (for example by changing the delimiting double-quotes to single-quotes) then it's not valid XSLT, because the value of the select attribute must be an XPath expression.

I think you want something like select="concat('INSERT INTO Table1 VALUES(', $a, ',', $b, ')'" except that

(a) you may want to add quotes around the values of $a and $b, I don't know;

(b) you need to think about whether it's necessary to protect yourself against SQL injection attacks.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference