On Mon, Nov 17, 2008 at 08:54:48PM +0300, Oleg Broytmann wrote: > On Mon, Nov 17, 2008 at 12:47:36PM -0500, Darren Govoni wrote: > > I think I will try to do the listen/notify outside of SQLObject and then > > fetch the objects using SQLObject. Should work. > > There could be a problem with transactions - opening a cursor outside of > SQLObject gives you a different transaction.
Oops, sorry - opening a new *connection* gives you a different transaction. But that (opening a new connection) is what you have to do anyway to work with the DB outside of SQLObject. Or you can try to use a low-level DB API connection hiding in the SQLObject's DBConnection class... Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss