[Zope] ZSQL Method & AUTHENTICATED_USER

[Aaron Straup Cope]

<sigh />

Thanks. It was a syntax issue. I think I tried every single variation on
passing variables to the method except that one. Sorry for the bother,
folks... :-)

On 18 Oct 2000, Jon Prettyman wrote:

> I'm pretty sure that all variables have to be passed in explicitly
> with SQLMethods.  Namespaces are not passed in.
> 
> Try specifying username as an argument in the ZSQLMethods edit form
> and pass it in like this:
>    <dtml-in expr=
> "lookup_by_username(username=REQUEST.AUTHENTICATED_USER.getUserName()">
> 
> (Untested....)
> 
> -jon
> 
> Aaron Straup Cope <asc@vineyard.net> writes:
> 
> > Hi,
> > 
> > I'm trying to perform a simple MySQL lookup based on the
> > AUTHENTICATED_USER. When I test the ZSQL method from the management
> > interface, everything works fine. However, when I try to call the method
> > from a DTML document, [it] returns nothing.
> > 
> > Is this a namespace issue? I'm stumped and hoping that I'm not staring
> > right past the problem. Can anyone point out what it is I am doing
> > wrong? Thanks,
> > 
> > a) DTML Document : foo
> > 
> > <dtml-with people>
> >  <dtml-in lookup_by_username>
> >   <dtml-var "username">
> >  </dtml-in>
> > </dtml-with>
> > 
> > b) ZSQL Method : people.lookup_by_username
> > 
> > select * from people where username = "<dtml-var 
> > "REQUEST.AUTHENTICATED_USER.getUserName()">"
> > 
> > 
> > 
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists - 
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
> 
>