just write it out like: SELECT * FROM table WHERE keywords LIKE '%<dtml-var name="my_var">%' jens on 2/8/01 7:17, Schmidt, Allen J. at aschmidt@nv.cc.va.us wrote:
I have been through the docs, searched a variety of locations, and cannot find anything on 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.
Ideally what I need to produce would be the query to search through some text in several fields by the keyword_variable (IF any keywords are provided) AND/OR within a specific category of information. If I can get the syntax to solve the above situation I think I can get <dtml-sqlgroup> to sort out what information is provided and construct the query accordingly.
Sorry for the length of this newbie question but I am stumped on this one. And, so ends my lurking status.
Thanks! Allen
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org 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 )