Categories

Archives

Did You Know?

Many of my system administration skills I learned due to maintaining a Pentium 90 (with Debian Linux) based firewall, router, DNS, mail, and web server from some time in '97 until around 2004 before I finally gave in and bought a wireless Linksys router (WRT54G).

Recent Comments

Tags

asp audio browser bug business coalesce code crash Database db debian extension framework imap internet legions linux metaverse mysql obscurity patch PHP postgresql properties release scp Second Life second life security session social media sound sql ssh subversion tables tortoisesvn tribes ubuntu virtual world web windows zend zend framework zf

Tag: tables

Dirty Rows and Audit Trails with Zend_Db_Table

There are various ways to update rows in a database table using the Zend_Db_Table components. You can use use Zend_Db_Table::update(), like so: $table = My_Table(); $table->update(array('age' => 22), 'id = 1'); or retrieve the row, and update it: $table = My_Table(); $row = $table->find(1)->current(); $row->age = 22; $row->save(); The big difference between the two approaches […]

Zend_DB_Select Woes

It's no secret, I'm a fan of the Zend Framework, which I've been using since version 0.15. A lot of components have been added since then, and many of the initial components have been refactored and enhanced, and have matured. And that includes the Zend_Db_Select component, which has been evolving quite nicely, and even Zend_Db_Table_Abstract […]