[Zope-DB] Retrieving Data from Z SQL in Python

Cliff Ford Cliff.Ford at ed.ac.uk
Thu May 19 02:16:42 EDT 2005

Christer Fernstrom wrote:
> Hello,
> I have a very simple Z SQL method that works fine when I test run it. But
> when I call it from a Python script (see below) and attempt to print the
> result, I get the following error:
> Error Type: TypeError
> Error Value: cannot concatenate 'str' and 'ImplicitAcquirerWrapper' objects
> ------ Python script -----
> # Import a standard function, and get the HTML request and response 
> objects.
> ##from Products.PythonScripts.standard import html_quote
> request = container.REQUEST
> data = context.getChunk1()
> for data_row in data:
>  print "data-row="+data_row
> return printed

You need to iterate over the columns in the row:

data = context.getChunk1()
for data_row in data:
   print "data-row="
   for item in data_row:
     print item + ' '
return printed

It is more normal to fetch one result row at a time:

for data_row in context.getChunk1():
     # and handle the results by column name
     print data_row.FirstName
     print ' '
     print data_row.Surname
return printed



More information about the Zope-DB mailing list