Re: [Zope] authenticated_user in Z SQL method not defined

Christoph Landwehr wrote at 2003-10-17 17:06 +0200:

But I can not use AUTHENTICATED_USER in an sql-querry like SELECT foo FROM users WHERE username=<dtml-var "AUTHENTICATED_USER.getUserName()" sql_quote>;

Why is AUTHENTICATED_USER not availabel in Z SQL methods?

"REQUEST" is not added to the DTML namespace of the Z SQL method's pattern. You can try "REQUEST.AUTHENTICATED_USER.getUserName()". Dieter