What can I do with a Results instance from a mysql query?
Hi all, Getting better at this Zope thing, but I still have problems. I want to retrieve data from a mysql database, store it in the session, and then return a page template that makes use of that data. This is all from within a python script. The problem I'm having is it doesn't like storing an entire results instance into the session. I don't want to create a dictionary and go through the fields one by one, but is there an equivalent of keys() for the Results object? Thanks very much, Alec Munro
Alec Munro wrote:
Hi all, Getting better at this Zope thing, but I still have problems. I want to retrieve data from a mysql database, store it in the session, and then return a page template that makes use of that data. This is all from within a python script. The problem I'm having is it doesn't like storing an entire results instance into the session. I don't want to create a dictionary and go through the fields one by one, but is there an equivalent of keys() for the Results object? Thanks very much,
Alec Munro
hi, have a look at http://www.zope.org/Members/spinwing/ZSQL_Results cheers, maik -- Maik Jablonski __o www.zfl.uni-bielefeld.de _ \<_ Deutsche Zope User Group Bielefeld, Germany (_)/(_) www.dzug.org
That is absolutely perfect. Thank you very much, Maik. Alec Munro -----Original Message----- From: Maik Jablonski [mailto:maik.jablonski@uni-bielefeld.de] Sent: August 7, 2002 3:44 PM To: Alec Munro Cc: zope@zope.org Subject: Re: [Zope] What can I do with a Results instance from a mysql query? Alec Munro wrote:
Hi all, Getting better at this Zope thing, but I still have problems. I want to retrieve data from a mysql database, store it in the session, and then return a page template that makes use of that data. This is all from within a python script. The problem I'm having is it doesn't like
storing an entire results instance into the session. I don't want to create a dictionary and go through the fields one by one, but is there
an equivalent of keys() for the Results object? Thanks very much,
Alec Munro
hi, have a look at http://www.zope.org/Members/spinwing/ZSQL_Results cheers, maik -- Maik Jablonski __o www.zfl.uni-bielefeld.de _ \<_ Deutsche Zope User Group Bielefeld, Germany (_)/(_) www.dzug.org
participants (2)
-
Alec Munro -
Maik Jablonski