Reply to: Boy, did I f*** up in a big way

[kingcook]

The worst one i did was a card processing system for a cash-sales team at a large publishing house. The system was written due PCI-DSS, the system took a £1 deffered payment against the card (to prove was genuine before user started keying an enourmous order), i forgot to set the flag to indicate the payment was to be deferred, noone noticed for over a week and i had inadvertantly charged 2500 credit cards a £1

I wondered why my credit card said something was authorised for £1 a few weeks ago, then magically disappeared within a few days

[Old Hack]

Dont you have cleaners?

My, rates have dropped.

[eek]

We don't want to hear about your fantasies and nasty thoughts on here thanks. There are other forums for that kind of stuff.

Speak for yourself


On second thoughts wnwpcs

[NorthWestPerm2Contr]

But do you wear her knickers?

We don't want to hear about your fantasies and nasty thoughts on here thanks. There are other forums for that kind of stuff.

[NotAllThere]

Now everybody knows who wears the trousers in our marriages....

But do you wear her knickers?

[NorthWestPerm2Contr]

Thought it only me......

Now everybody knows who wears the trousers in our marriages....

[BrilloPad]

Thought it only me......

It is just you. NorthWestPerm2Contr to lieing to see if there were any jessies on the forum.....

[Halo Jones]

Hoovering is my job in the house

That's what the staff are for..

[SeekingIT]

Phew!!!

Hoovering is my job in the house

Thought it only me......

[wurzel]

Always use BEGIN TRANSACTION AND ROLLBACK (then COMMIT) when running UPDATE/DELETE!!!!!

I always do. Just forgot this time as I copied and pasted from a very similar script & was in a rush as I was trying to hit a deadline on another project.

That said, they have to run such scripts time & time again - they need a screen in the UI to do this but they're so busy fire fighting that nobody has the time to do it.

[Ketchup]

What if you've committed the transaction?

I normally notice my mistake before the commit when millions of record have been updated!

The worst one i did was a card processing system for a cash-sales team at a large publishing house. The system was written due PCI-DSS, the system took a £1 deffered payment against the card (to prove was genuine before user started keying an enourmous order), i forgot to set the flag to indicate the payment was to be deferred, noone noticed for over a week and i had inadvertantly charged 2500 credit cards a £1

[NorthWestPerm2Contr]

phew!!

she just announced that the hoover should be up and running by tonight.

Hoovering is my job in the house

[EternalOptimist]

I agree with your wife. This hoovering business sounds like hard work. Not that i ever intend to try it.

phew!!

she just announced that the hoover should be up and running by tonight.

[NorthWestPerm2Contr]

If it's any consolation I've just run a script on UAT & forgot to put something in the where clause.

282,059 records updated They're right in the middle of UAT testing too.

Flak jacket & helmet time for me.

Always use BEGIN TRANSACTION AND ROLLBACK (then COMMIT) when running UPDATE/DELETE!!!!!

[wurzel]

I installed SSMS Tools, automatically does everything within a transaction

What if you've committed the transaction?