Full Disclosure mailing list archives
Re: Question: is this exploitable?
From: "Jonathan A. Zdziarski" <jonathan () nuclearelephant com>
Date: Sat, 18 Oct 2003 22:44:40 -0400
Escaping quote characters might work OK in MySQL, but it is at best only a database-dependent solution. Take a look at Oracle, instead of double-quotes, single-quotes are used. And instead of being escaped, they are simply doubled (e.g. ' becomes ''). You'd have to write an entirely different mechanism to untaint data bound for Oracle...and another one for other different database implementations. This is why placeholders are a better solution. For one, they keep you in a database-independent environment (which makes sense, since you're using DBI). For another, they insure you don't have to worry about accidentally missing the escaping of some data. On Sat, 2003-10-18 at 22:36, Paul Tinsley wrote:
I don't believe this is a true statement.
_______________________________________________ Full-Disclosure - We believe in it. Charter: http://lists.netsys.com/full-disclosure-charter.html
Current thread:
- Question: is this exploitable? Paulo Pereira (Oct 18)
- Re: Question: is this exploitable? Jonathan A. Zdziarski (Oct 18)
- Re: Question: is this exploitable? Jason Dixon (Oct 18)
- Re: Question: is this exploitable? Randal L. Schwartz (Oct 18)
- Re: Question: is this exploitable? John Sage (Oct 18)
- Re: Question: is this exploitable? Codex (Oct 18)
- Re: Question: is this exploitable? Jonathan A. Zdziarski (Oct 18)
- Re: Question: is this exploitable? Paul Tinsley (Oct 18)
- Re: Question: is this exploitable? Jonathan A. Zdziarski (Oct 18)
- Re: Question: is this exploitable? Paul Tinsley (Oct 18)
- Re: Question: is this exploitable? Jonathan A. Zdziarski (Oct 18)
- Re: Question: is this exploitable? Jonathan A. Zdziarski (Oct 18)