Re: [Zope] MySQL queries in Python

Usually you install the database adaptor ZMySQLDB and make queries through a ZSQL Method object. On Tue, 1 Aug 2006, Muk Yan wrote:

Dear Coveted Braintrust,

I was wondering if anyone had any experience with MySQL queries in Python in Zope:

import MySQLdb import string

request = container.REQUEST session = request.SESSION

result = (context.aq_parent).selects.select_from_table()

print result return printed

WHERE select.select_from_table() IS:

SELECT name FROM person WHERE ID = <dtml-var "REQUEST.SESSION.get('person_id')">

I know the MySQL query works, but I get garbage results from the python script (<Shared.DC.ZRDB.Results.Results instance at 0x132a5c88>). All I want is to contain the results of the SQL query in a list or container.

Thanks and take care, Muk Yan

--