RobertBolton.com

The database was upgraded to MS SQL 9 and required me to use 2005 SQL Server Management Studio instead of Enterprise Manager. While trying to import a .csv file, I ran into a number of errors and spent awhile trying to figure out what the problem was. If you get a similar error, the problems […]

I have seen a number of articles popping up over the last couple of months detailing performance optimization for PHP. There seemed to be a spurt of articles two or three years ago covering the same topic. However, back then, the articles dealt with trivial (in my opinion) practices, such as not enclosing variables in […]

Select statements (via Zend_Db_Table_Select) can now be passed into the findManyToManyRowset method of Zend_Db_Table_Row_Abstract. In ZF 1.0, I couldn’t order my result sets coming back from MySQL, which was a pain. Now, I can use the following code, where $m is a Row object:

<?php$select = $m->select()->order(array(’startDate DESC’,‘endDate ASC’));
$tripreportRowset = $m->findManyToManyRowset(‘Tripreport’, ‘TripreportMountain’,NULL,NULL,$select);
?>

If you don’t need to order by multiple columns, then don’t pass […]

Ever since I upgraded to Gutsy Gibson (7.10), Open Office has been having problems. It would open fine, but everyime I tried to access the menu, the screen would redraw and the menu would disappear. It wasn’t a huge deal, as I could shortcut most things, such as saving, undoing, bolding and closing the window. […]

Found out about an interesting Blackhat link building technique. You can use search engines to find web logs that are publicly accessible, then you can refer your site to the site with the accessible weblogs, and viola, you have a link in the eyes of the search engine. For example, this site has the list […]