Re: rules to escape special chars and avoid SQL Injection -- JAVA400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Hi John,

While this is a Java list, SQL cuts across all langages, so I think it
is appropriate to say that probably the single most important tool to avoid
SQL injection is prepared statements. Google will give you lots of other
guarding information.

Joe Sam

Joe Sam Shirah - http://www.conceptgo.com
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International? http://www.jguru.com/faq/I18N
Que Java400? http://www.jguru.com/faq/Java400

----- Original Message ----- From: "John Arevalo" <johnarevalo@xxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Wednesday, March 23, 2011 3:45 PM
Subject: rules to escape special chars and avoid SQL Injection

Hi list,

This is my first post, i didn't find appropiate list for PHP
development, i apologize for it.

i need to escape properly any value read from input user. i found it's
posible escape single quote with two single-quotes,

do you know all rules for avoid SQL Injection?

Thanks for your replies.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.