ps for completeness
here is the testquery ZSQL which works fine when tested in the ZMI and manually inputting the id variable.
select * from tblEmployees where department = (<dtml-sqlvar id type="string">) order by 'location'
I have 'id' in the argument field
Thanks
On 11/2/07, michael nt milne <michael.milne@gmail.com
> wrote:
Hi Josef
<ul>
<li tal:define="query here/testquery" tal:repeat="result python:query(id='IT')">
<span tal:replace="repeat/result">firstname goes here</span>
</li>
</ul>
gives the same
> AttributeError: Results instance has no __call__ method
As does
<span tal:replace="repeat/result/firstname">First Name</span>
As does
<span tal:replace="result/firstname">First Name</span>
!
Thanks for your help. Not easy this ZPT!, even when you have read the documentation :-)
On 11/2/07, Josef Meile <jmeile@hotmail.com
> wrote:
Hi Michael
michael nt milne schrieb:
> yeah I have modified to this
>
> <li tal:define = "query here/testquery"
> tal:repeat="result python:query(id='IT')">
> <span tal:replace="python:repeat['result'].firstname">First
> Name</span>
> </li>
>
> but get this as a result. Thanks for the reply.
>
> Module
Products.PTProfiler.ProfilerPatch, line 32, in __patched_call__
> Module Products.PageTemplates.ZRPythonExpr, line 47, in __call__
> - __traceback_info__: query(id='IT')
> Module Python expression "query(id='IT')", line 1, in <expression>
> AttributeError: Results instance has no __call__ method
I suspect that result isn't a dictionary. Why don't you try to print
result instead and see its type? Try this:
<span tal:replace="repeat/result"></span>
You could also try the other sintax for your zpt:
<span tal:replace="repeat/result/firstname">First Name</span>
Regards
Josef
_______________________________________________
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev
)
--
michael
--
michael