Re: [Bodington-developers] Problem with prepared statement in Postgresql

[Jon M. <jo...@te...>]

Looks like a little edit to the method;

String SqlDatabase.quotedSQL( String )

is required.  Proper SQL provides only one escape character ' which is 
only used to represent the ' character within the string literal.  
PostgreSQL has an additional non-standard escape method using back 
slashes - will fix your problem but must only be used on postgreSQL 
connections.

Jon

Andrew Booth wrote:
> Atif and I have found a problem with prepared statements and Postgresql.
>
> If one of the ? replacements is a string containing  an '@' character, the
> string gets truncated at that point.  Has anyone else noticed this?  Anyone
> got a work-around?
>
> Aggie
>
> ____________________________________________
> Andrew G Booth
> Professor of On-Line Learning
> Faculty of Biological Sciences
> Garstang Building
> University of Leeds
> Leeds LS2 9JT
> U.K.
> Tel: +44-113-343-3142  Fax: +44-113-343-3167
> email: a.g...@le...
> personal email should be sent to:
>        an...@ag...
> ____________________________________________
>
>
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
>