using xxamp for a lamp (linux,mysql, php) environment to do development on php? perhaps you are already running an iis server (or even the others through iis) … in that case the default ports for webhost and mysql db will already be in use. to get apache to listen on other ports you will have…

alright, there is actually a way to do this built into excel! good, it is as it should be! format > column > autofit selection obsolete idea:ever wondered how to adjust all columns to the smallest width necessary to fit all data, all at once? i just figured this one out, but wish i knew…

I often get tripped up doing an update of one table from fields in other table in access sql. i’m not sure if its because its different in other sql’s, but in access it is required to do an inner join to the table which is being updated within the foreign update query. Here is…

Gone are my days of crawling ftp uploads. Now I just upload zip archives and expand with this nifty little php file, which works on linux machines, and even provides a gui listing all .zip files in the folder it is located within. Read more here.

URI limit in sajax

another embarrassingly simple fix which took me a little while to figure out: While passing a hierarchical list to sajax to write to a file, I failed to get a return response. I thought this might have something to do with the heavily nested hiearchy which I was having problems with earlier in the day.…

SWF Flash Maps

Are Flash (SWF) maps worthwhile, or just a gimmick? Many sites have been putting up some pretty slick SWF maps lately, and the big map api’s (google, yahoo, mapquest — ve?) have followed suite. There’s obviously something cool about these SWF maps. However, when I tried to figure out if it would be worth creating…