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 <[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED]
> 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 - [EMAIL PROTECTED]
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 )
