All, I am just getting my feet under me with Zope and trying to figure out how to get the following functionality. I have a MySQL table with a notes field that stores, as you might expect, notes about a record. I need to get a reasonably functional search capability for this field (boolean AND and NOT at least) that returns the serialnumber field of the record it is attached to. Upgrading to the latest version of MySQL isn't optimal. The Text Index capabilities of the ZCatalog object seem to be perfect for my needs, but I can't figure out how I would implement the ZCatalog object to search the notes field through my ZSQL object. I could write a script to get the functionality I want, but don't want to reinvent the wheel and would also like to grok how the ZCatalog works anyway. Is this doable and can someone either tell me how to do it or point me to documentation that would be readable by a capable novice? Thank you for your time. John P. Withers
On Fri, 09 May 2003 17:30:17 -0700 GMT (..2:30 where i live(GMT+2) ) John P. Withers asked the Zope mailinglist about the following: ... JPW> The Text Index capabilities of the ZCatalog object seem to be perfect JPW> for my needs, but I can't figure out how I would implement the ZCatalog JPW> object to search the notes field through my ZSQL object. ... JPW> Is this doable and can someone either tell me how to do it or point me JPW> to documentation that would be readable by a capable novice? http://www.zope.org/Members/rbickers/cataloganything :) -- Geir Bækholt
participants (2)
-
Geir Bækholt -
John P. Withers