cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcelo F. Ochoa" <>
Subject Re: Bug in SQLTransformer "substitute-value"
Date Thu, 30 Aug 2001 11:04:05 GMT
Gerd Mueller wrote:

>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 

>Best Regards,
  Best regards, Marcelo.

Marcelo F. Ochoa -
Do you Know DB Prism? Look @
More info?
Chapter 21 of the book "Professional XML Databases" (Wrox Press
Chapter 8 of the book "Oracle & Open Source" (O'Reilly
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:
For additional commands, email:

View raw message