Recent tweets
- @Wilona the grey text isnt working out too well there. Great gifs though. 2012/02/03
- @JanLomax mostly just lazing about but I have the maths books open again now 2012/02/02
- @JanLomax everything is great. Hope you are too. 2012/02/02
- @JanLomax hey hot stuff. xx 2012/02/02
- @Drewjbeckett applying for the Blue Man Group? ;) 2012/01/24
- @holleyhop I think I'm gonna cut all mine off in the spring :) 2012/01/24
- Logan's Run is on :) 2012/01/24
Category Archives: Geekery
My very own twitter client.
Followers on Twitter may have noticed that I’m now posting using a client called alanjames. This is really just Spaz but now registered at Twitter under my own name.
Here’s the how and why I’ve done that.
For some months now …
Posted in Geekery
2 Comments
Within-group aggregates with another wrinkle.
Recently when optimising an SQL query I needed to return a specific subset of records from a large table. The brilliant Common Queries Tree pointed me in the right direction, but the examples didn’t quite cover my specific case.
I …
Tethering Jolicloud with a Nokia 6500 Classic
Yesterday I plugged my Nokia 6500 Classic phone into my Jolicloud powered netbook, told the network manager I was on a Vodafone contract and bang, instant 3G internet access. It could hardly be simpler.
Once its set up, you can …
Spaz, the twitter client.
I use a Twitter client named Spaz. Now if you’re from the UK the name might strike you as being a bit distasteful, perhaps even offensive. Get over it, its just a random sound in most of the world. …
Posted in Geekery
Leave a comment
MySQL: Row N was truncated; a solution
You’re importing some data into MySQL and using LOAD DATA INFILE so you can do a SHOW WARNINGS afterwards. Every line of your import file has a warning:
| Warning | 1262 | Row 1 was truncated; it contained more …