[Zope] Quick question on ZSQL methods...

[jcoleman@austin.rr.com]

I was writing a SQL method to pull one record out of a database that
contains account information for the current authenticated user, and
it's not recognizing the <!--#var AUTHENTICATED_USER--> in the ZSQL
method:

select * from accounts
 where name = '<!--#var AUTHENTICATED_USER-->';

Zope tells me:


Error, exceptions.KeyError: AUTHENTICATED_USER
SQL used:
Could not render the query template!


Substituting <!--#var AUTHENTICATED_USER--> with an actual name works
fine.  Any ideas on how to get this to work?  Or am I going about this
all wrong?


Thanks,
John