[Zope] ZSQL "OR" search help

15 Jul 2001

      Hello,

How can I perform a "OR" search on a SQL database field using a web form ?

E.g. :

I have a SQL database table with fields "name", "surname" and the following
records:

Jimmy    Carter
Ronald    Reagan
George   Bush
Bill           Clinton

I would like to search the "name" field through a web form and write :

George OR Jimmy

And it should return :

Jimmy      Carter
George    Bush

Thanks for your help.

Fabrizio C.