08.25.06
Quote
“…domestic violence isn’t funny. Domestic tacos are.” —Clifton, co-worker
08.14.06
Learning New Things
The yacht club is sending out a newsletter so it’s my job to pull a list of addresses from the database. Lucky me. The thing is, I can just barely get around in SQL Land…complicated queries aren’t something I have any experience with. I finally came up with this:
SELECT CONCAT_WS(';', CONCAT_WS(' ',First,Last),StreetAddress,City,State,ZipCode) FROM WYCDatabase WHERE ExpireQtr >= 30;
This gives a list of current members in the format of:
Full Name; Street Address; City; State; ZIP
I could probably do better, but I’ll take it for now. Hopefully our newsletter person can use it or I’m going to have to manipulate the data with some scripts or something. Another thing I don’t have much experience with…regular expressions make my brain hurt.
I really shouldn’t be complaining–I’ve always meant to learn this stuff sooner or later, anyway.
Wetdog
Alright sysadmins–if you’re using Wetdog to lockdown firefox, be aware that the user logging in needs to have write permissions to “wetdog.cfg” in the directory firefox is installed in.
08.12.06
Quote
“If you asked a red-stater to draw a picture of Jesus and a picture of a terrorist—the picture of the terrorist would look more like Jesus actually did.”
—Pete Stone, co-worker