Re:Sqlmap: Automatic SQL injection and database takeover tool
by derpmeister on Thursday July 05, 2012 @03:35PM
(#4204585)
You could do without using a CTE, it's just not as convenient most of the time. Alternatively, you could pass the column names to a function (using a prepared statement, no less) and let that function figure out which columns are valid. If your tables change frequently, this would save more time in the long run.
[ Parent
| on HN ]
Re:Sqlmap: Automatic SQL injection and database takeover tool
by tptacek on Thursday July 05, 2012 @03:41PM
(#4204612)
We are talking about manual, purpose-built functionality designed to prevent SQLI in queries that use bound parameters. Don't move the goalposts: nobody is saying it's particularly hard to avoid SQL injection, just that bound parameters aren't a panacea.