[triangle-zpug] SQL search

Charles Fulton triangle-zpug@starship.python.net
Fri, 9 Aug 2002 10:22:54 -0400


Thought I'd try the local people before the main Zope list.

I need to do string searches in SQL and I would like to look for fragments
anywhere in a field.  Basically i'd like to send "%<userinput>%" to the
database so the people don't have to put in their own wildcards.

It would be nice to use sql-group since I have multiple fields that can be
searched but I don't see a good way to do this.  Can I do the string
building in DTML or should I go ahead and create the entire query with a
python script?

Suggestions?

Thanks,
Charlie