[Zope] Searching a Gadfly database

Matthew Lindfield Seager subscriptions@sagacity.com.au
Wed, 26 Mar 2003 16:43:34 +1100


Hi,

I've been attempting (unsuccessfully) for a couple of days now to 
implement a simple search facility on a Zope based intranet I inherited 
responsibility for. (Forgive me if this is a really basic question, I'm 
much more comfortable with PHP and MySQL).

After going around in numerous circles and butting my head up against a 
wall almost constantly I've finally worked out that:
a) The text to search on is in a Gadfly database AND
b) Gadfly databases don't support the SQL "LIKE" operator

The manual says something about using python and regular expressions or 
something instead of "LIKE" but it's enough of a battle for me puzzling 
out this Zope stuff let alone learning some Python too...

Oh, and the reason I decided to try the SQL route was because Z Catalog 
didn't seem to store any useful information that I wanted to search on. 
It (understandably) only catalogued information ABOUT the Z SQL Method, 
not information IN the Z SQL Method.

Can anyone help me with a way to search a Gadfly database: either using 
SQL, Z Catalog or some other method.

Thanks in advance!
Matthew