[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