[Zope] Quick question on ZSQL methods...

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