[Zope-DB] how to fetch and set a value from a result object

Robert Van Overmeiren vanoverr@uniteddrugs.com
Thu, 12 Dec 2002 12:31:24 -0700


I would like to know how to interate over a Z SQL Method result object,
which returns a single unique result, and set a variable's value to this
unique result within a python external method.

My query is passed a username and it selects the latest login time for the
username. I tried this:

timestamp = context.select_log_time(username=Username)

but 'timestamp' gets set to the result object rather than just the unique
value within it.

When this 'timestamp' value is returned to an HTML page, it displays:

<Shared.DC.ZRDB.Results.Results instance at 0x8f7dd24>

Can the value within the result object be 'fetched' and set to a variable
from within the python script?

Bob V