June 18, 2009

Sorting Multiple Columns With MySQL

Ever wanted to sort your MySQL results by several columns?

SELECT * FROM orderspecs ORDER BY height, depth, width;

Now what if you want the columns to have different sort orders in the sub-sorted columns? No problem. Just specify the order for each column.

SELECT * FROM orderspecs ORDER BY height DESC, depth ASC, width DESC;

June 12, 2009

Google Gravity

Gotta love it…  A Chrome experiment called “Google Gravity”  I totally love it.  Works in Safari 4 and somewhat in FireFox as well.

April 29, 2009

Setting an HTML element’s class with Javascript

I was pulling my hair out trying to figure out why I was getting a parse-error with this code… DUH!

document.getElementById('test').class = "test"

“class” is a reserved name, of course… So you access it with:

document.getElementById('test').className = "test"

April 22, 2009

Plesk Backup Error: ‘ERROR Unable to open /opt/psa/var/apspkgarc/archive-index.xml’

I was getting the following error when trying to use Plesk’s backup function:

ERROR Unable to open /opt/psa/var/apspkgarc/archive-index.xml

The solution is to visit the “Application Vault” under the “Server” tab of your Plesk interface.  The file gets auto-generated at that point.

For more information on how to use Plesk’s backup feature, read this post

A List Apart: In Defense of Eye Candy

A List Apart: Articles: In Defense of Eye Candy.

Wonderful article on design…