Does SQL Transformer's substitution feature use the JDBC placeholder approach? This is desirable for query caching and avoiding string encoding problems (especially single quotes).
The placeholder approach in JDBC, from Jack Herrington's article "Can't Anyone Write Good SQL These Days?" (http://www.devx.com/dbzone/Article/17158): Statement statement = connection.createStatement(); query = "SELECT name FROM book WHERE author=?"; statement.setString( 1, getName() ); statement.executeQuery( query ); The substitution feature, from the Cocoon SQL Transformer documentation (http://cocoon.apache.org/2.1/userdocs/transformers/sql-transformer.html): <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> <query> select id,name from employee_table where name = <sql:substitute-value sql:name="username"/>' </query> </execute-query> </page> __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
