Gerd Mueller wrote:
>Hi,
>
>I use the latest cocoon_20_branch.
>
>The SQLTransformer replaces the ' by " while processing the
><substitute-value> tag. But this is an error especially for
>HypersonicSQL, e.g. if the substitute value is
>"where column='value'" replacing the ' by " gives an SQLException.
>
>I don't think that the replacement is necessary at all since
>it should be left to the developer depending on the database
>if s/he has to use ' or ".
>
For Oracle databases the right escape sequence for ' (simple quote) is
'' (two simple quote, not double quotes").
I think that this is the right replacment according to Ansi SQL
specification.
>
>
>Best Regards,
>Gerd
>
>--
>
Best regards, Marcelo.
--
Marcelo F. Ochoa - [EMAIL PROTECTED]
Do you Know DB Prism? Look @ http://www.plenix.com/dbprism/
More info?
Chapter 21 of the book "Professional XML Databases" (Wrox Press
http://www.wrox.com/)
Chapter 8 of the book "Oracle & Open Source" (O'Reilly
http://www.oreilly.com/catalog/oracleopen/)
-----------------------------------------------
Lab. de Sistemas - Fac. de Cs. Exactas - UNICEN
Paraje Arroyo Seco - Campus Universitario
(7000) Tandil - Bs. AS. - Argentina
Te: +54-2293-444430 Fax: +54-2293-444431
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
