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
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )