Oleg Broytmann a =E9crit :
> On Thu, Nov 16, 2006 at 01:27:39AM +0000, Matthew Wilson wrote:
>> I want to add a modified_date column to my table that updates
>> automatically when a row is updated.
>> How do I do this using sqlobject?
> SQLObject cannot do that. Worse, if you do this via
> connection.query("CREATE TRIGGER...")
> you have to find a way to draw the updated value back to SQLObject's
> cache. You can set cacheValues=3DFalse but then every access to any col=
> will be resulted in a separate SELECT.
If your database is accessed only through sqlobject, it would be much
simpler to implement some method that would be called at each update.
This would simply set the modify date in the row.