Re: update with select in MYSQL

[thomas bui]

I have the same problem. I tried as you sugested using the constant value in the mysql command line. It works. But not in the xslt. some suggestion/solution is appreciated. Thanks.

Thomas Bui

...
<sql:execute-query>
<sql:query isupdate="true"> UPDATE MYTABLE_MATCH SET GROUP_ = ( SELECT
GROUP_ FROM MYTABLE_MATCH WHERE KEY_= ./sql:key_a )
WHERE GROUP_ =( SELECT GROUP_ FROM MYTABLE_MATCH WHERE KEY_= ./sql:key_b)
</sql:query>
</sql:execute-query>
...