Hi, Please refer to http://lists.zope.org/pipermail/zope-coders/2002-February/000804.html for an explanation. A solution is to store the path to the query (e.g. '/DB/SQL/anSQLQuery' rather than the query object itself), then use "restrictedTraverse" to look it back up again when you need to. On Sat, 2002-05-18 at 10:08, p.t. wrote:
I'm trying to remember what was the last SQL query called registering to a session the "pointer" to a SQL instance, something like:
anSQLquery = container.DB.SQL.anSQLqury
Howevere, I get this error:
Error Type: InvalidObjectReference Error Value: Attempt to store an object from a foreign database connection
just when attempting to write to a session the variable anSQLquery.
The traceback diagnostic is not very helping to me; it says:
(Info: (('Products.Transience.TransientObject', 'TransientObject')
referring to:
Connection.py, line 345, in commit
I did examine the code, but unfortunately my limited knowledge of such a sophisticated Python code gives me no possibility to uderstand what's wrong.
Any suggestion on how to avoid this error message? TIA, p.t.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )