Schmidt, Allen J. writes:
> .... how to resolve a query which I need to read:
>
> SELECT * FROM table WHERE keywords LIKE '%keywords_variable%'
>
> <dtml-sqltest> has 'op=like' and when set to 'type=string' produces the LIKE
> operation in the query, with single quotes, but I cannot get it to 'wrap'
> the keywords with the percent characters and THEN the single quotes to
> produce that which I have in the query above.
<dtml-sqltest expr="'%%%s%%' % keywords_variable" column=keywords_variable ...>
Dieter
_______________________________________________
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )
