Monday, July 16, 2007

Math lesson: 1 + 0 = 0?

They say - every day you should learn something new.
Well, I certainly did today.
I would have never thought that if you're concatenating two columns in SQL and one of them is NULL, then... Correct!
Based on server settings the result may very well be NULL!

Now, that is probably a well-known fact, however, logically speaking it doesn't make sense...

Friday, July 6, 2007

You have it, but you can't use it!

So I have this cellphone: Sony Ericsson W810i. It's ok - does what I want it to do. Mostly. However there's a minor annoyance: playlists can be only created from within the phone itself and even after that they are not accessible as files. Bummer. So I was looking into writing my own media player which would support playlitsts the right way, but ran into another issue: this phone doesn't support JSR 234 - Advanced Multimedia Supplements, so for example EQ function won't be supported. I wasn't able to find a native (non Java) SDK either. So the hardware is there, but you can't use it... Do we still live in the 19th century? :-(