--- Joseph Ferguson <joelemma@yahoo.com> wrote:
> Seems like there is a problem parsing string
> literals
> with wildcards escaped.
>
> The searchStringEscape looks like '\'
>
> Search strings of '\%' and '\_' both result in
> unknown
> escape character SQLExceptions. '\\%' and '\\_' seem
> to work.
>
> This isn't a new problem 2.X versions did it too, I
> just never saw it before.
>
Joeseph,
One possible workaround is to use prepared statements.
I have not used the above with one, but driver has
responsibility to form string correctly with prepared
statement.
Regards, george
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|