<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 )