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.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
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
