Scripts posted recently tagged to like in Kelpi

1- 1 of 1.

Zope zsql method like clause

to zope zodb zsql like by txus

<dtml-comment>
When your database supports SQL ,with this function you can use the Like % string % clause from sql. 
</dtml-comment>
select count(FIELD1) from TABLE1 where FIELD2 = <dtml-sqlvar PARAM1 type="string"> and FIELD2 like <dtml-sqlvar "'%' + PARAM2 + '%'" type="string">

hits counter