4 ms·
I wonder how many responses of : Cantaloupe');DROP TABLE Food;-- ol' Randal is going to get (or some permutation thereof). Figuring that Randal is pretty smar
by Balgair 11y ago
I wonder how many responses of :
Cantaloupe');DROP TABLE Food;--
ol' Randal is going to get (or some permutation thereof). Figuring that Randal is pretty smart, I bet he has a piece of code to parse out that. Still, anyone here have a good hack that can just nuke days of his time whilst completing this form? Only other one I can think of him using is (for Matlab):
Cantaloupe'); clear all; clc; close all;
- gefh 11y agoThe data gets collated in a Google sheet, so I think he'll be fine. Or at least if he finds a bug, it'll get fixed.
- myblake 11y agoYeah I suspect google sheets is not obviously vulnerable to sql injection at this point in the game.
- jameshart 11y agoIt's not going to -stay- in a google spreadsheet, though. You have to assume it will get loaded into some other system. there are opportunities to exploit that system, potentially. Kind of a 'stored' injection vulnerability.
- kenbellows 11y agoyeah it's going into a docs spreadsheet rather than a db, at least directly, so I don't think he has much to worry about
- aliem 11y agoI'll have to play with spreadsheet injection then
- splawn 11y agoHe is hip to sql injection. https://xkcd.com/327/ https://xkcd.com/327/
- JshWright 11y agoThat's the joke.
- jameshart 11y agoThis isn't Randall's first rodeo. On his color survey, he mentioned this (http://blog.xkcd.com/2010/05/03/color-survey-results/ http://blog.xkcd.com/2010/05/03/color-survey-results/): "A couple dozen people embedded SQL ‘drop table’ statements in the color names. Nice try, kids."
- misingnoglic 11y agoI assume he'd use python for the parsing with the CSV library, so just including lots of quotes, commas, \t, and \n characters would probably mess something up.