Month: April 2003

Ok, so iTunes (and 99 cents) will get you that song you want, but it’s not an MP3 is it? It’s some sort crazy protected format that limits what you can do with it, right? Sure… I think it’s in DRM format or something…

I’ve got a Mac with sound output. I’ve got a Mac with sound input. I’ve got cables. I’m not some audiophile phreak who would care about the degradation of the digital/audio/digital conversion process that much. Wait a minute, that’s too complex, what if I download a song, burn it onto an audio CD and then rip that CD back into MP3’s, what happens? Problem solved?

I guess the problem is still somewhat the laziness factor. I mean, the whole idea behind an easy to use, and affordable online music service is that it’s much simpler to pay for it, and play by the rules than to break the rules, or find creative ways around the rules.

I’ve never liked rules…

Dear Apple, I’m sick of this:

Please fix it immediately.

Thanks…

I was attempting to find the number of characters in a field in Microsoft SQL Server, so I tried this:

SELECT
  length(desc)
FROM
  foo;

That was the logical thing to try, and guess what? It worked just fine in MySQL, but no dice in Microsoft SQL Server, so after some searching and asking others I found out that Microsoft SQL Server has something called datalength, so I tried this:

SELECT
  datalength(desc)
FROM
  foo;

Well, that tells you the size of the field, but not the size of the data within the field… Oh, that’s right, rtrim is your friend…

SELECT
  datalength(rtrim(desc))
FROM
  foo;

Success! We get the number of characters instead of the size of the field itself. MySQL is blunt and just gives you the answer you want… Microsoft SQL Server has to get all technical on you, and make you clarify and specifically ask for what you want…

And if there’s something I missed, or there’s some other way to do it, let me know…

(Special thanks to O'Reilly for their SQL in a Nutshell info…)

Yesterday we had 720 requests from a robot named “Robot”, or maybe it was a spider named “Robot”.

Look, if you’re gonna write a robot, at least give it a cool name like Bender or Calculon, or something…

Hmmm, maybe it was named after “The Robot” from Lost In Space.

Mozilla Stuff…

• LiveHTTPHeaders
• Mycroft
• Checky
• pnhtoolbar
• PrefBar
• uabar
• Various mozdev projects…

What has Internet Explorer done for you lately?