[Zope] Quick question on ZSQL methods...

[Andrew Kenneth Milton]

+----[ 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