Zope ZSQLMethod Question

[Steve Williams]

Phil Harris wrote:

. . .

if in doubt always use the recognised method, in this case
AUTHENTICATED_USER.getUserName.

if in your SQL method you use <dtml-var
"AUTHENTICATED_USER.getUserName()">,
all will be well.

If you haven't yet got the Zope Quick Reference, go get it now, you
won't
regret it. ;)

. . .

--------------------

Well, actually, I knew that AUTHENTICATED_USER is an object, but I still
can't seem to get it to work.

I alternate between

    "can't render the query template"

after fiddling with quotes, dtml-var vs. dtml-sqlvar, etc.

and

        Zope Error

        Zope has encountered an error while publishing this resource.

        Error Type: NameError
        Error Value: AUTHENTICATED_USER

        Troubleshooting Suggestions

           This resource may be trying to reference a nonexistent object
or
           variable AUTHENTICATED_USER.
            . . .

when invoking an ZSQLMethod with <dtml-var
"AUTHENTICATED_USER.getUserName()"> from, say, an index_html folder.

As to the ZOPE Quick Reference, neither Cyberunner's ZOPE Page or
Stephan's Zope Portal, the sources returned by a search on zope.org,
respond to me.

Thanks for your reply.

Steve Williams