Re:A guide to preventing SQL injection
by tptacek on Tuesday September 15, 2009 @02:04PM
(#824355)
My advice is, pass page= as your pagination and pass 1/0 in for ASC or DESC. If you have selectable columns, number them in the parameters, don't name them.
Point being, when you compose the query, you should never be inserting text from parameters; you should be converting parameters into known-good values.
Point being, when you compose the query, you should never be inserting text from parameters; you should be converting parameters into known-good values.