[Zope-DB] zSQL method question
Sat, 1 Mar 2003 21:22:47 +0100
Saturday, March 1, 2003, 6:58:11 PM, you wrote:
MS> I apologize if this is a particularly stupid question, but...
MS> I want to search against a text field in MySQL using a zSQL method such that
MS> my search query is wrapped in % wildcard characters.
MS> select * from xyz where
MS> <dtml-sqltest search_query column=txCriteria op=like type=string>
perhaps (untested) this will work ?
<dtml-sqltest expr="'%'+str(search_query)+'%'" column=txCriteria op=like type=string>