Hall Of Shame
- Ron2K
- Forum Technical Administrator
- Posts: 9050
- Joined: 04 Jul 2006, 16:45
- Location: Upper Hutt, New Zealand
- Contact:
Re: Hall Of Shame
So, I was attempting to upgrade the instance of SQL Server 2005 on my work PC to SQL Server 2008, and was presented with this gem - guess we now know the preferred game of the SQL Server developers.
Kia kaha, Kia māia, Kia manawanui.
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Hall Of Shame
not technically HoS material, but i would happily drown this individual...
:/...
both courtesy of TDWTF
Code: Select all
// Check if date is valid!
String allowed = "not allowed";
sql = "SELECT IF(DATE(?) <= DATE(?),'allowed','not allowed')";
stmt = con.prepareStatement(sql);
stmt.setString(1, firstDate);
stmt.setString(2, terminationDate);
rs = stmt.executeQuery();
while(rs.next()){
allowed = rs.getString(1);
}
rs.close();
stmt.close();
if(!allowed.equalsIgnoreCase("allowed")){
throw new Exception("Termination Date to early!");
}
both courtesy of TDWTF
Most people would sooner die than think; in fact, they do so - Bertrand Russel
-
- Forum Moderator
- Posts: 10000
- Joined: 05 Feb 2004, 02:00
- Processor: Intel i5-4690K @ 4.5GHZ
- Motherboard: ASUS Maximus VII Formula
- Graphics card: ASUS GTX970 Strix
- Memory: 4 x 4GB Corsair Dominators
- Location: Messing with your Mind
- Contact:
Re: Hall Of Shame
rustypup, for those of us who have been out of the coding game for a while, please enlighten us
Art Williams wrote:I'm not telling you it is going to be easy, I'm telling you it's going to be worth it.
-
- Registered User
- Posts: 26022
- Joined: 13 May 2004, 02:00
- Location: Getting there...
- Contact:
Re: Hall Of Shame
From a total non-programmer....
Shouldn't that rather read:
Shouldn't that rather read:
"Termination Date too early!"
MOOD - Thirsty
A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
A surprising amount of modern pseudoscience is coming out of the environmental sector. Perhaps it should not be so surprising given that environmentalism is political rather than scientific.
Timothy Casey
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Hall Of Shame
in essence, the tjop is using a sql server to calculate whether one date occurs prior to another... it's so much worse than that when you get into it, but that's what is being achieved... it is a masterpiece...
Most people would sooner die than think; in fact, they do so - Bertrand Russel
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Hall Of Shame
Most people would sooner die than think; in fact, they do so - Bertrand Russel
Re: Hall Of Shame
Haha TDWTF is awesome
а плечьми буйство струйка. Дверь Твоем юдоли. Виновником неразлучен страшиться невинность милосердье сладчайший. Век под вне Оно Нет сия тук. Все вас совоздыхая устремится ком мню возблеснув разверзают лик мой сопрягаешь. Неправды но Ту светлеет Неправых Ни ум смотреть.
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Hall Of Shame
Most people would sooner die than think; in fact, they do so - Bertrand Russel
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Hall Of Shame
Most people would sooner die than think; in fact, they do so - Bertrand Russel
-
- Registered User
- Posts: 7333
- Joined: 18 Jul 2005, 02:00
- Location: Somewhere unknown... being ninja
Re: Hall Of Shame
Thanks to rusty for the redirect, he wins one candy
____________________
---I'm out of my mind right now, but feel free to leave a message...---
---I'm out of my mind right now, but feel free to leave a message...---
-
- Registered User
- Posts: 1
- Joined: 15 Sep 2010, 08:28
Re: Hall Of Shame
Nice post "hall of shame"
nicer reply: @neon_chameleon.......lolz
nicer reply: @neon_chameleon.......lolz
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Hall Of Shame
- Spoiler: (show)
Most people would sooner die than think; in fact, they do so - Bertrand Russel
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: Hall Of Shame
I didn't know there were still Geocities web pages from 1996 online...rustypup wrote:
- Spoiler: (show)
Re: Hall Of Shame
That's the first thing I thought of as well with those background GIF's...