[Zope] dtml-sqlgroup broken

Andy Dustman andy@dustman.net
24 Feb 2002 01:29:05 -0500


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.