Hi
 
I am a Newbie to zope.
I am interested in working in zope and have been involved in work related with Pythonscripts and PostgreSql and Page Templates.
I have become stuck at a point and I am not able to find what to do next.
I am using a python Script to run a ZSQL method and then the values are to be sent to the Page Template to be displayed.The Script is:
 
from Products.PythonScripts.standard import html_quote
r = context.ond.db.zqll_clin    # this is a zsql method in a different folder at root
for x in r:
   print x['Id'],x['Name'],x['tt']   # these are the fields of the table
return r
The error message I get is

Error Type: KeyError
Error Value: 0
Am i not being able to get the record set from the database?Because if I give a print command in the loop it does not work.HEnce it may not be entering the loop.What is the method to access a Zsql Method which is another folder?

If there is someone who could help me out here it would be very helpful.Since i am stuck with this problem for 2 days and I have tried other possibilities.

Regards
John Kunchandy
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.380 / Virus Database: 213 - Release Date: 7/24/2002