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