Re: SQL escape what to do with } - Kazys Jocionis - com.mysql.lists.java

8 messages in com.mysql.lists.javaRe: SQL escape what to do with }

From	Sent On	Attachments
fractals	03 Aug 1999 02:38
Kazys Jocionis	03 Aug 1999 04:58
Jan Fedak	03 Aug 1999 05:34
Kazys Jocionis	03 Aug 1999 07:17
Kazys Jocionis	03 Aug 1999 07:26
Cris Perdue	03 Aug 1999 08:00
C Javier Castro Pena	03 Aug 1999 09:26
Christian Mack	03 Aug 1999 10:40

Subject:	Re: SQL escape what to do with }
From:	Kazys Jocionis (webm...@junet.net)
Date:	08/03/1999 07:17:26 AM
List:	com.mysql.lists.java

thank you for a prompt responce.

I was thinking there is something like a function quote() in DBI. Well. Its OK with ' escaping like \' or '' also with \ escaping like \\

but there is a another problem with } lets say " select * from agents where password= '}' " if we escape it like a " select * from agents where password= '\}' " we get an error.

with mySQL such a query is OK but seems Java is frustrated with \}

any thoughts?

Thank you again.

Kazys

Try 'd''artanjan' or "d'artanjan".

Jan

Kazys Jocionis wrote:

Hello,

could someone point me to the right way to escape SQL characters like ' using JDBC please. I mean queries like "SELECT id FROM friends WHERE name = 'd'artanjan' "

thank you in advance

Kazys

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.