Have a look at this:
 
 
 
 
Jonathan
----- Original Message -----
From: Muk Yan
Sent: Tuesday, August 01, 2006 2:50 PM
Subject: [Zope] MySQL queries in Python

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


_______________________________________________
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 )
_______________________________________________
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 )

Reply via email to