cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcelo F. Ochoa" <moc...@ieee.org>
Subject Re: Bug in SQLTransformer "substitute-value"
Date Thu, 30 Aug 2001 11:04:05 GMT
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 - mochoa@ieee.org
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: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message