Serious Problem with sql:transformer

[Alexander Schatten]

I user SQL transformer also to insert (and update) datasets in the 
database, as this is rather handy. It works basically fine, but today it 
took me hours to figure out one problem. (Cocoon 2.04)

I use

  <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
               <query>
....
statements with an INSERT INTO ... SQL

this works, but today I figured out, that the SQL transformer fails when 
a "?" question mark is part of the text!!! obviously because it is 
interpreted as prepared statement parameter.

this is very bad, as I based some forms on this strategy.

Is there a solution for this problem known?

Would be really great to get some comments!

Alex

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]