+----[ jcoleman@austin.rr.com ]--------------------------------------------- | 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? <!--#call "REQUEST.set('username',_.str(AUTHENTICATED_USER))" --> I use this, and then refer to username from then on. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | Milton ACN: 082 081 472 | M:+61 416 022 411 |72 Col .Sig PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|Specialist