Alric Aneron wrote:
Hello, I am new to Zope and DTML.
I am trying to use a python script to call a Z SQL method. The python
script also has a list that <dtml-in inside the ZSQL method interates
over. so my python script:
-----python script
words = ['one', 'two']
context.REQUEST.set('wordlist', wordlist)
rs = context.myzsqlmethod()
return rs[0,2]
-----z sql script:
SELECT * FROM table
WHERE
<dtml-in words>
column1 LIKE ('<dtml-var "'%'+sequence-item+'%'">' OR
column2 LIKE '<dtml-var "'%'+sequence-item+'%'">') <dtml-unless
sequence-end> AND </dtml-unless>
</dtml-in>
---------------
But it doesn't want to, gives me..
*Error Type: NameError*
*Error Value: name 'wordlist' is not defined
*I tried feeding the variable into the ZSQL arguments list, but i got
something like "cannot concatenate a module with a str"
Can anyone please help me?
Thank you!
It complains about 'wordlist' because it is not defined anywhere.
Perhaps you mean 'words' in the second line?
To pass a param to the ZSQL method, just say::
context.myzsqlmethod(words=words)
This will put it in the namespace.
--jcc
--
"Building Websites with Plone"
http://plonebook.packtpub.com/
Enfold Systems, LLC
http://www.enfoldsystems.com
_______________________________________________
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 )