J Cameron Cooper schrieb:
> 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
>> <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>

And dont use <dtml-var > in ZSQL Methods.
In your example, use <dtml-sqlvar sequence-item type=string> instead.
Even if you hardcode the wordlist, but even more if its coming
from request somewhere.
Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to