[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': <PythonScript instance at 0176FB70>, 'context':
<Folder instance at 01852A30>, 'container': <Folder instance at
01852A30>, '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