Oh cock it

[EternalOptimist]

maybe the content SHOULD be null, and you are some sort of PreCog ?



spooksville

[MarillionFan]

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.

Better hope you don't work with SY. He'll be jumping up and down higher than a racehorse in a Newbury paddock.

[Sockpuppet]

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.

[thunderlizard]

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.

[Sockpuppet]

phew !

Haven't you got a dev db to test these queries on ?

This is the dev db. The other users are enjoying the extra fag break though.

[amcdonald]

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.

You've watched Office Space, you know what to do...

[FiveTimes]

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.

phew !

Haven't you got a dev db to test these queries on ?

[Sockpuppet]

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.

[amcdonald]

What kind of PI insurance

[Sockpuppet]

Not thinking while writing update queries like that are the reason I have PI insurance