100% Geek The Adventures of Peter Boughton:
CFML; Web Development; Photography.


Archives for August 2006

[SQL] Look Behind You

Where I work we have a generic database table which stores a variety of values associated with different things. Each entry has a type, id and description, along with a set of generic alpha_1..9 and numeric_1..9 columns.

Today I needed to check whether a certain value was in the table but wasn't certain where it might be - all I knew was that it was text, so I started writing the following SQL...

read more...

Posted by Peter on 21-August-06 at 18:34 ~ 0 comments ~ Category: , ,


MiniEmotes Maximised

I have upgraded my old set of minimalist emoticons, which were 8-bit black-on-white and didn't look good on anything other than a white background.

The new edition of MiniEmotes now uses alpha-transparency to ensure they look good against any background.

read more...

Posted by Peter on 01-August-06 at 19:30 ~ 0 comments ~ Category: