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 )