Hello, I tried to use the AUTHENTICATED_USER object in a ZSQL method. Like: INSERT INTO MYTABLE(USER) VALUES('<dtml-var "AUTHENTICATED_USER.getName()" sql_quote>') But Zope tells me that AUTHENTICATD_USER is not known. Why that? Thanks Ulli -- ----------------- Die Website Effizienzer ------------------ luna-park Bravo Sanchez, Vollmert, Wisser GbR Ulrich Wisser mailto:u.wisser@luna-park.de Alter Schlachthof, Immenburgstr. 20 Tel +49-228-9654055 D-53121 Bonn Fax +49-228-9654057 ------------------http://www.luna-park.de ------------------
On Fri, 18 Feb 2000, Ulrich Wisser wrote:
Hello,
I tried to use the AUTHENTICATED_USER object in a ZSQL method. Like:
INSERT INTO MYTABLE(USER) VALUES('<dtml-var "AUTHENTICATED_USER.getName()" sql_quote>')
But Zope tells me that AUTHENTICATD_USER is not known. Why that?
Thanks
Ulli
Hi Ulli, I had that problem too. Put AUTHENTICATED_USER in the "Arguments" field. That should solve it. Greetings, Michiel Toneman --
From a Sun Microsystems bug report (#4102680): "Workaround: don't pound on the mouse like a wild monkey."
Michiel Toneman wrote:
On Fri, 18 Feb 2000, Ulrich Wisser wrote:
Hello,
I tried to use the AUTHENTICATED_USER object in a ZSQL method. Like:
INSERT INTO MYTABLE(USER) VALUES('<dtml-var "AUTHENTICATED_USER.getName()" sql_quote>')
But Zope tells me that AUTHENTICATD_USER is not known. Why that?
I had that problem too. Put AUTHENTICATED_USER in the "Arguments" field. That should solve it.
Hi , you do not have to put it in your arguments field. You can use things like INSERT INTO YOURTABLE(USER) VALUES (<!--#sqlvar "REQUEST.get('AUTHENTICATED_USER')" type=string-->) or SELECT USER,ROLE FROM YOURTABLE WHERE ROLE IN ( <!--#in "(REQUEST.get('AUTHENTICATED_USER')).roles"--> '<!--#var sequence-item-->'<!--#unless sequence-end-->,<!--#/unless--> <!--#/in--> ) anywhere in your ZSQLMethode. -- _________________________________________________________ Andreas Heckel andreas@aHIT.de
participants (3)
-
Andreas -
Michiel Toneman -
Ulrich Wisser