#3 cannot create Z SQL Method in LocalFS

[Anonymous]

I created a ZSQL method in the localfs object, but zope
interprets the
zsql method as a dtml method containing the following
text:

## Z SQL Method "retrieve"

##connection_id: MySQL_database_connection

##arguments:

##

select head,url,source from main order by iDate

Subsequesnt dtml-in calls to "retrieve" don't query the
DB:

Traceback (innermost last):

File
/usr/local/zope/2.5.1/lib/python/ZPublisher/Publish.py,
line 150,
in publish_module

File
/usr/local/zope/2.5.1/lib/python/ZPublisher/Publish.py,
line 114,
in publish

File
/usr/local/zope/2.5.1/lib/python/Zope/__init__.py, line
159, in
zpublisher_exception_hook

(Object: fudo)

File
/usr/local/zope/2.5.1/lib/python/ZPublisher/Publish.py,
line 98, in
publish

File
/usr/local/zope/2.5.1/lib/python/ZPublisher/mapply.py,
line 88, in
mapply

(Object: index_html)

File
/usr/local/zope/2.5.1/lib/python/ZPublisher/Publish.py,
line 39, in
call_object

(Object: index_html)

File
/usr/local/zope/2.5.1/lib/python/OFS/DTMLDocument.py,
line 127, in
__call__

(Object: index_html)

File
/usr/local/zope/2.5.1/lib/python/DocumentTemplate/DT_String.py,

line 473, in __call__

(Object: index_html)

File
/usr/local/zope/2.5.1/lib/python/DocumentTemplate/DT_In.py,
line
628, in renderwob

(Object: retrieve)

InError: (see above)

Error Type: InError

Error Value: Strings are not allowed as input to the in
tag.