News for hackers. Stuff that matters.
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.
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.