[Zope] Quick question on ZSQL methods...

[jcoleman@austin.rr.com]

David Kankiewicz wrote:

> jcoleman@austin.rr.com wrote:
> >
> > 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?
> >
> I believe the correct way to get the username would be:
>
> <!--#var "AUTHENTICATED_USER.getUserName()"-->
>
> untested..
>
> Regards,
> David
>

Hmm... nope, same thing.  This is getting kind of frustrating.

John