Winmail.dat Attachments For Linux Thunderbird

This is only going to be a rant and a link to Andrew Beacock's blog post solving that pesky winmail.dat attachment issue for linux users.

I never had this issue until this morning when a project manager sent over an email with an attachment.

Sheesh Microsoft, can we stop making the proprietary apps please!?

Regular Expressions in MySQL

Do you need to limit your SQL results and LIKE '%foo%' isn't giving you a narrow enough result list?

Well, I'm sure you know how to narrow down those SQL results with a regex! So all there is to it is the REGEXP operator! Yay!

Example:

SELECT * FROM table WHERE column REGEXP 'data[0-9]';


You get the point; now enjoy! Cheers!

MySQL Search and Replace

I recently had to update some information in MySQL. Yes, I'm sure you're thinking, "yea, so...that's easy!". But, the way the data was entered in the column was more like an entire paragraph! The information I needed to change was only a last name in the paragraph. So, obviously I didn't want to type out the entire paragraph again with my edits just so i can UPDATE the table. So instead, MySQL has a nice replace function built in. Yay!

The code will look as follows:
UPDATE your_table set your_column=replace(your_column,'Smith','Jones');

And now your_column will replace all occurrences of "Smith" with "Jones".

Cheers!

Hello, Android SDK

So in an attempt to stay on budget and yet keep myself entertained through this recession, I finally set up my Android SDK on one of my computers. I also finished up my first app! Ok, ok, so it's the generic "hello world" app that all newbies start off with, but hey I still haven't decided what I'd like to build. It's always just fun to tinker around a system anyway.
Let the fun begin!

Cheers!

Where's My Ubuntu Screensaver Admin?!

I think this will probably be more of a reminder for me, but in case anyone else has this curious issue with Ubuntu Gutsy Gibbon, then read on!

For whatever reason, I do not have "Screensaver" listed under System>Preferences. I'm using XScreenSaver since gnome-screensaver seemed to just freeze after any amount of time. Anyhow, if you need to configure your settings for XScreenSaver all you need to do is type in xscreensaver-demo in a shell. Tada!

Sheesh, I had to google that every time and then follow it up with a "doh!" once I read what to do!

Cheers!

It's 2009 and I Am Back!

Well, it has been over two months since my last post. I have been unfortunately out of ideas on what to blog about. So, perhaps I will slowly stray away from my usual format of blogging about technical recipes and code to bantering on about anything random. Hmmm...we'll see.

Anyhow, happy 2009! I was given an awesome present of a [t-mobile] G1. Yay! I've only had it for a little bit over a week now, but it is awesome. I've managed to get root thus far; but stay tuned for more updates.