You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by Gerd Mueller <ge...@smb-tec.com> on 2001/08/30 11:21:20 UTC
Bug in SQLTransformer "substitute-value"
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 ".
Best Regards,
Gerd
--
________________________________________________________________
Gerd Mueller gerd@smb-tec.com
SMB GmbH http://www.smb-tec.com
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
Re: Bug in SQLTransformer "substitute-value"
Posted by "Marcelo F. Ochoa" <mo...@ieee.org>.
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