Reply to: Just spent hours chasing down a bug

[scotspine]

Stick to VB.NET...

eh?

[dinker]

Post it on http://thedailywtf.com/Default.aspx

[Churchill]

Not one educated under New Labour.

HTH

Why bother spending all that money on education when you can pay Bob and his cousins 25 quid a week to do the job?

[DimPrawn]

That, ladies and gentlemen, is not "coding" it is SQL. An educated monkey could write it.

Not one educated under New Labour.

HTH

[cupidstunt]

Like AtW?

Churchill

[sasguru]

spotty faced junior coder. .

Like AtW?

[Churchill]

That, ladies and gentlemen, is not "coding" it is SQL. An educated monkey could write it.

[PRC1964]

If I ever see in a SQL Statement, code to the effect of

UPDATE tableName
SET col1 = etc(@col1),
col2 = @col2,
col3 = @col3
WHERE primaryKey = primaryKey;

Both You and DP are gonna get the blame

Sadly, now that it's been posted here it will be picked up by Google and copied by thousands of spotty faced junior coders. Expect to see it turn up all over the place.

[singhr]

A huge collective sigh of relief just went up from CUK as they realised you're doing the coding on this project

[EternalOptimist]

UPDATE IT_contractors_to_investigate
SET all_tickety_boo = true
WHERE cuk_username IN ('swamp')



HTH

Insert (@bargepole)
INTO Primarolo.@rsehole
where @bargepole.greasy
= true

[swamp]

I'm working on the IR35 database for HMR&C

UPDATE IT_contractors_to_investigate
SET all_tickety_boo = true
WHERE cuk_username IN ('swamp')



HTH

[HairyArsedBloke]

Been going round in circles.

In the old days before senility and long term alcohol abuse I would have spotted that in seconds.

Welcome to my world.

[MrMark]

hmmm bit newbie error that

would not the use of a WHERE statement solve those problems?

You fell into the trap. A bit misleading the way I put it though - it's more to do with the way different vendors treat null values.

[DimPrawn]

A huge collective sigh of relief just went up from CUK as they realised you're doing the coding on this project

I'll have it completed before the next millenium.

[Weltchy]

It's a surprisingly good name for a function call!

If I ever see in a SQL Statement, code to the effect of

UPDATE tableName
SET col1 = etc(@col1),
col2 = @col2,
col3 = @col3
WHERE primaryKey = primaryKey;

Both You and DP are gonna get the blame