[Zope] ZSQLmethods don't return a list?!

alex@quad.com.ar alex@quad.com.ar
Tue, 4 Sep 2001 18:50:03 -0300


hey guys

I created a ZSQL Method "SELECT * FROM users" which returns 10 rows
now in a python script:
type = context.type
sql = context.mySqlMethod()
return type(sql)

this returns: <type 'instance'>
while I expected <type 'list'>

the problem is, I wanted to do something like
return sql[2:4]

but I get an error:

Error Type: TypeError
Error Value: sequence index must be integer

Traceback (innermost last):
  File C:\ZOPE\lib\python\ZPublisher\Publish.py, line 223, in publish_module
  File C:\ZOPE\lib\python\ZPublisher\Publish.py, line 187, in publish
  File C:\ZOPE\lib\python\Zope\__init__.py, line 226, in
zpublisher_exception_hook
    (Object: LockableItem)
  File C:\ZOPE\lib\python\ZPublisher\Publish.py, line 171, in publish
  File C:\ZOPE\lib\python\ZPublisher\mapply.py, line 160, in mapply
    (Object: foo)
  File C:\ZOPE\lib\python\ZPublisher\Publish.py, line 112, in call_object
    (Object: foo)
  File C:\ZOPE\lib\python\Shared\DC\Scripts\Bindings.py, line 324, in
__call__
    (Object: foo)
  File C:\ZOPE\lib\python\Shared\DC\Scripts\Bindings.py, line 354, in
_bindAndExec
    (Object: foo)
  File C:\ZOPE\lib\python\Products\PythonScripts\PythonScript.py, line 363,
in _exec
    (Object: foo)
    (Info: ({'script': &lt;PythonScript instance at 0176FB70&gt;, 'context':
&lt;Folder instance at 01852A30&gt;, 'container': &lt;Folder instance at
01852A30&gt;, 'traverse_subpath': []}, (), {}, None))
  File Script (Python), line 3, in foo
    (Object: guarded_getitem)
  File C:\ZOPE\lib\python\AccessControl\ZopeGuards.py, line 148, in
guarded_getitem
  File C:\ZOPE\lib\python\Shared\DC\ZRDB\RDB.py, line 252, in __getitem__
TypeError: (see above)


Shouldn't ZSQL methods return a list of dictionaries or anything similar to
it ??
any suggestions ?

Alex