RE: fail-safe queries

2003-04-02 Thread Dave Dyer
> >Please don't take these suggestions as sarcasm. Relying on your tools to catch >anything other than syntax errors is a bad idea. It builds in a false sense of >security. I couldn't possibly disagree that Q/A is a good idea, but so is defense in depth. That's why we train drivers AND install

RE: fail-safe queries

2003-04-02 Thread John Griffin
Sent: Tuesday, April 01, 2003 4:24 PM To: [EMAIL PROTECTED] Subject: fail-safe queries I'm a little concerned by the possibilty of a malformed query accidentally destroying a whole databse. For example, a badly constructed boolean, intended to select exactly one row, but which actually mo

RE: fail-safe queries

2003-04-02 Thread Rob Brown
Dave Dyer [mailto:[EMAIL PROTECTED] Sent: Tuesday 01 April 2003 23:24 To: [EMAIL PROTECTED] Subject: fail-safe queries I'm a little concerned by the possibilty of a malformed query accidentally destroying a whole databse. For example, a badly constructed boolean, intended to select exact

fail-safe queries

2003-04-01 Thread Dave Dyer
I'm a little concerned by the possibilty of a malformed query accidentally destroying a whole databse. For example, a badly constructed boolean, intended to select exactly one row, but which actually modifies all rows. update mytables set data='who' where row='1234'; (updates 1 row) verses