March 16th, 2007
The Singapore MRT has to be one of the best public rail transport systems in the world (I fancy the Tokyo train/subway system as well - the fare adjustment machine is one of those “since sliced bread” ideas), but they still have room to screw up in a Daily WTF-worthy way.
This sign at Raffles Place MRT used to show train arrival times:
It’s been there for about 3 days, was still there when I checked this morning.
January 20th, 2007
Found a forwarded email with this image of a receipt from a local restaurant in Raffles Hotel sitting around in my inbox while clearing my inbox (trying to achieve the state of “Inbox Zero”):
Yeah I’d like some nachos with my slut.
December 26th, 2006
Saw this on a Christmas brochure while buying some pastry from the local Delifrance cafe:
I immediately thought of Mr. Hankey the Christmas Poo (of South Park fame).
While the resemblance is not uncanny, I’m pretty sure that’s one log cake I don’t want to eat.
December 22nd, 2006
Just noticed an insidious “bug” in MySQL when you use “AND”s instead of commas to separate the fields you are updating in your SET clause. Being a little rusty in SQL, I entered something like the query below while trying to make a quick fix to some records:
UPDATE characters
SET alignment = 'Neutral Evil'
AND last_name = 'Majere'
WHERE first_name = 'Raistlin'
Much to my consternation, the record appeared to have disappeared when I tried to query for it. After much bewildered cursing, I came across MySQL bug #15928: update syntax error not detected (this is not an actual bug though). As it turns out, MySQL does a logical AND and the result is that the ‘alignment’ field is set to ‘0′ since 'Neutral Evil' AND last_name = 'Majere' results in false. And MySQL casts it to ‘0′. Grrr. Luckily I was able to revert the changes by finding the record again with the new ‘0′ alignment value (was using an auto-committing MySQL GUI client, no ROLLBACK available).
November 16th, 2006
I don’t normally post short entries on non-technical topics nor link to LiveJournals (just kidding!), but I’ll have to make an exception for this one. Check out these Smooth-E Babyface ads, probably one of the most creative commercials you’d have seen in awhile.
Oh and while I’m “off-topic”, Bleach fans who want to find out more about the opening song (Rolling Star) in the latest episodes should check out this thread on YUI (the singer). I’m now totally hooked on Tomorrow’s Way (YouTube video) and I Remember You (another YouTube video), and of course, the Bleach OP.