The following Z SQL Method used to work prior to 2.5.0, but now produces an error (2.5.1b1 included): Arguments: spam:int:optional SELECT spam, eggs, sausage FROM foo2 <dtml-sqlgroup where> <dtml-sqltest spam type="int" optional> </dtml-sqlgroup> Error Type: TypeError Error Value: unbound method __init__() must be called with instance as first argument Traceback (innermost last): File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/andy/Zope-2.5.1b1-src/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: SELECT) File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_edit) File /home/andy/Zope-2.5.1b1-src/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_edit) File /home/andy/Zope-2.5.1b1-src/lib/python/Shared/DC/ZRDB/DA.py, line 174, in manage_edit (Object: SELECT) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 350, in cook (Object: <string>) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 179, in parse (Object: <string>) File /home/andy/Zope-2.5.1b1-src/lib/python/DocumentTemplate/DT_String.py, line 246, in parse_block (Object: <string>) TypeError: (see above) Line numbers may be shifted slightly due to debugging code inserted. The line where the error occurs is: DEBUG and DLOG('parse_block: %s(%s)' % (`scommand`,`blocks`)) r=scommand(blocks) 2002-02-24T06:13:11 PROBLEM(100) DT DEBUG parse_block: <class Shared.DC.ZRDB.sqlgroup.SQLGroup at 0x8628afc>([('sqlgroup', 'where', <DocumentTemplate.DT_HTML.HTML instance at 0x89d999c>)]) I'd also like to draw attention to collector issues 6, 15, and 192... I particularly would like to see 15 implemented... If it will help, I'll put this in the collector as well. Basically, Z SQL Methods are nearly useless at this point. Andy Dustman PGP: 0x930B8AB6 @ .net http://dustman.net/andy You can have my keys when you pry them from my dead, cold neurons.