[Zope] dtml-return'ing the result of a SQL select (does not work)

[Dr. Peer Griebel]

Hi,

I just tried to implement something as described in the How-To
	How To: Use GenericUserFolder with an SQL database
It does not work. The problem boils down to the fact that I can't
dtml-return the result of a SQL query.

I wrote the Z SQL Method 'qryTest':
	select * from mytable

This method can be executed without problems. It displays all rows in
the table.

And I wrote a DTML Method 'returnData':
	<dtml-return qryTest>

When calling the method I get
	Resource not found

Traceback (innermost last):
  File D:\Programme\uZope\lib\python\ZPublisher\Publish.py, line 214, in
publish_module
  File D:\Programme\uZope\lib\python\ZPublisher\Publish.py, line 179, in
publish
  File D:\Programme\uZope\lib\python\Zope\__init__.py, line 202, in
zpublisher_exception_hook
    (Object: ElementWithAttributes)
  File D:\Programme\uZope\lib\python\ZPublisher\Publish.py, line 167, in
publish
  File D:\Programme\uZope\lib\python\ZPublisher\HTTPResponse.py, line
299, in setBody
  File D:\Programme\uZope\lib\python\ZPublisher\HTTPResponse.py, line
511, in notFoundError
NotFound: (see above)

I'm using Zope 2.1.4, WinNT. What's going on here? Can anybody help?!
Thank you!

-- 
connection reset by
      Peer

_______________________________________________________________________
Dr. Peer Griebel                                  Tel. +49 7581 4831 23
Geschäftsführer                                   Fax. +49 7581 4831 11
Knoll Informationssysteme GmbH                   http://www.knoll-is.de
Dreiköniggasse 17                               mailto:peer@knoll-is.de
88348 Saulgau                        privat: mailto:peer.griebel@gmx.de