Freeware Applications and Games for the Nokia N97 phone

I've knocked up a quick application that lists freeware applications and games for the Nokia N97 phone.

You can view it at http://www.davecozens.com/n97/

Also, I don't know about anybody else, but I've some terrible scratches on the lens caused by the lens cover. Not good. For more info go to http://www.davecozens.com/n97/scratches.htm

Oooops. Lost blog

Yup, once again I completely forgot to post anything remotely important..

Although I've been doing some work on a web based javascripty ColdFusion HTML editor that can parse ASP includes (but prevents editing of include files). Content management on the cheap, if you will. Without the overhead of importing existing content.

That's entertaining.

That and tinkering about with jMeter and BadBoy (why did they call it that? why?) for load & system testing. A useful combination indeed...

Anyways. Back to work...

Single Quotes & Query of Query

Well that was fun. Since I'm working in Ireland at the moment there's about a gazillion people with single quotes in their names.

"Query of Query" really doesn't cope very well with that.

CF automagically escapes them with 2 single quotes ('') and then any where clause doesn't find them. Not very useful.

If you use preservesinglequotes, the query is syntactically incorrect. So you get an error. Also, not very useful.

However, if you replace each single quote with 2 single quotes you end up with a param that looks like this 'O''''Reilly'. Somewhat bizarrely, that works a treat.

So, if you want to search for O'Reilly and his mates (from parameter searchValue) using Query of Query, you need to do this: -

#replace(ucase(searchValue),"'","''","all")#

That's rather horrible to read, isn't it. So to make it readable (by adding a bunch of spaces): -

#replace(
ucase(searchValue),
" ' ",
" ' ' ",
"all"
)#


But obviously, you don't want the spaces there in reality.

So there you go. Query of Query is completely mental.
Dave

Boy sent £44,000 in eBay parcel

According to the Beeb, somebody slipped whilst doing their ebay packing, and instead of dropping a PS2 in the box, they accidentally put £44,000 in there instead. And sent it off to an unwitting teenager.

"Result", you might think.

But no! He phoned the police instead. I bet he does always his homework and is never home late either!

More here -> bbc news article

Fun with Helium Balloons - Economy Class

Some nutter has just flown over 193 miles in a chair suspended from a bunch of helium balloons.

Sounds like fun...

more ->