[Zope] Quick question on ZSQL methods...

[Bill Anderson]

jcoleman@austin.rr.com wrote:
...
> > > 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?
> > >
> > I believe the correct way to get the username would be:
> >
> > <!--#var "AUTHENTICATED_USER.getUserName()"-->
> >
> > untested..
...
> Hmm... nope, same thing.  This is getting kind of frustrating.
> 
> John


<shot in the dark>
try:
where name = <!--#var AUTHENTICATED_USER-->


I think the problem is in the ticks and semicolon ...
</shot in the dark>

Bill