3 ms·
query = sprintf("select count(*) from data where %s = ?", column) results = sql.execute(query, filter_value); So long as you leave the "value" portion of t
by falcolas 12y ago
query = sprintf("select count(*) from data where %s = ?", column)
results = sql.execute(query, filter_value);
So long as you leave the "value" portion of the query as a '?' (or %s, or whatever your connector requires) and don't use direct user input for the column names, you're still safe from SQL injection.