Archive for September, 2008

Accessing Remote Drive in Linux via SSHFS

There may be a case where you may want to access a certain directory or drive on a remote machine, and mount it to your local PC. For example, I have a headless CentOS box running Apache where all of my web application codes are sitting. Editing those web application codes are a nightmare when [...]

Tags: . .

Drop it, Dropbox!

It’s been awhile since I’m searching for a perfect online backup application. I’ve tried many, but none have really captured my attention. Not until I’ve tried Dropbox.
Dropbox is a free, multi-platform, online backup and synchronization application. My first attraction to Dropbox is because the client tools supports Linux. It also suports Mac OSX, and oh [...]

Tags: . .

Save MySQL Output to a Text File

I have just found out a nifty little trick regarding MySQL output the other day. I just had to put this up as a reminder to myself, and also to share with the viewers.
Let say, you want to have the output of your SELECT statement created to a text file. The MySQL database server could [...]

Tags: .

SQL Select Statement with Comma-Separated List Condition

I have one problem the other day; Why does my “SELECT * FROM tbl WHERE col IN (@list)” does not work? The col datatype is int, while the @list parameter is a comma-separated varchar.
The Problem
In a stored procedure, I’m composing a SELECT statement with a WHERE clause in which the column condition datatype is integer, while [...]

Tags:

Why the Honda City is ugly

Ok, the Honda City is not that ugly; I just thought it would make a great headline. But still, the Honda City is not exactly everyone’s dream car. Are Honda designers not talented? Surely they could come up with a better design? Yes, quite easily, I’m sure. It’s just that Honda is applying a slightly [...]

Tags: .

RSS

Subscribe Now:

About Me

nazham.comBorn and lives my life in the wonderful country of Malaysia. I have been a Software Engineer, and loving it. I built this site as a main purpose of sharing and giving back to the community. Please feel free to give feedbacks and let me know if there's any errata found on this site.