<div id="RTEContent"> Hello, I am new to Zope and DTML.<br> 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:<br> -----python script<br> words = ['one', 'two']<br> context.REQUEST.set('wordlist', wordlist)<br> rs = context.myzsqlmethod()<br> return rs[0,2]<br> -----z sql script:<br> SELECT * FROM table<br> WHERE <br> <dtml-in words><br> column1 LIKE ('<dtml-var "'%'+sequence-item+'%'">' OR<br> column2 LIKE '<dtml-var "'%'+sequence-item+'%'">') <dtml-unless sequence-end> AND </dtml-unless> <br> </dtml-in><br> ---------------<br> But it doesn't want to, gives me..<br> <strong>Error Type: NameError</strong><br> <strong>Error Value: name 'wordlist' is not defined<br> <br> </strong>I tried feeding the variable into the ZSQL arguments list, but i got something like "cannot concatenate a module with a str"<br> Can anyone
please help me?<br> Thank you!<br> </div><p>
                <hr size=1>Yahoo! Shopping<br>
Find Great Deals on Holiday Gifts at <a href="http://us.rd.yahoo.com/mail_us/footer/shopping/*http://shopping.yahoo.com/;_ylc=X3oDMTE2bzVzaHJtBF9TAzk1OTQ5NjM2BHNlYwNtYWlsdGFnBHNsawNob2xpZGF5LTA1
">Yahoo! Shopping</a>