ZSQLmethods don't return a list?!
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
participants (2)
-
alex@quad.com.ar -
Chris Withers