Oleg Broytmann a écrit :
> 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=False but then every access to any column
> will be resulted in a separate SELECT.
>
> Oleg.
>
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.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
