Not thinking while writing update queries like that are the reason I have PI insurance 
-
-
What kind of PI insurance
Doing the needful since 1827 -
The kind that needs to pay out when you wipe an entire column by updating it to NULL.
Luckily I'd just taken a backup and I'm in the process of correcting the mistake.Comment
-
phew !Originally posted by Sockpuppet View Post
Haven't you got a dev db to test these queries on ?Comment
-
You've watched Office Space, you know what to do...Originally posted by Sockpuppet View PostDoing the needful since 1827Comment
-
This is the dev db. The other users are enjoying the extra fag break though.Originally posted by FiveTimes View PostComment
-
ooh. Then you'd be on one of those sites where getting a dev db refresh requires a fortnight's notice, fililng in a ridiculously long Excel-template-style request form, and a phone call that's a masterpiece of persuation worthy of Mr Smith Goes to Washington. Ah, memories.Comment
-
Well there are only 3 users of this db (it's a reporting db) and we work in an office with no supervision and a hundred miles or so from main client co office so we're generally a law unto ourselves. Luckily we also control the back ups.
Come to think of it we also have pcs that are not on the main network so we fix as we please. Not half bad this contract really.Comment
-
Better hope you don't work with SY. He'll be jumping up and down higher than a racehorse in a Newbury paddock.Originally posted by Sockpuppet View PostWhat happens in General, stays in General.You know what they say about assumptions!Comment
-
maybe the content SHOULD be null, and you are some sort of PreCog ?
spooksville
(\__/)
(>'.'<)
("")("") Born to Drink. Forced to WorkComment
Comment