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