I am trying to do a SQL LIKE query on a lastname attribute of a zclass. ie. show me all the lastnames LIKE 'cronkyte' should return cronkite... I am trying to use TextIndexNG to do this. I need to get the Similarity search part of TextIndexNG working. I can create a working TextIndexNG using the Zope management interface, this index will return EXACT matches, but not similar ones. However the ZMI does not appear to have a way to activate the Similarity search. How do I use the Similarity search in a query? Thanks I am using zope 2.6.1 mandrake linux 9.1 python 2.1.x Joel Jensen
Similarity search must not be enabled. It is always available (according to the docs). Use '%someterm". -aj --On Dienstag, 30. Dezember 2003 19:12 Uhr -0600 Joel Jensen <joel@joeljensen.com> wrote:
I am trying to do a SQL LIKE query on a lastname attribute of a zclass. ie. show me all the lastnames LIKE 'cronkyte'
should return cronkite...
I am trying to use TextIndexNG to do this.
I need to get the Similarity search part of TextIndexNG working.
I can create a working TextIndexNG using the Zope management interface, this index will return EXACT matches, but not similar ones.
However the ZMI does not appear to have a way to activate the Similarity search.
How do I use the Similarity search in a query?
Thanks
I am using zope 2.6.1 mandrake linux 9.1 python 2.1.x Joel Jensen
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Hi Joel, Joel Jensen wrote:
I am trying to do a SQL LIKE query on a lastname attribute of a zclass. ie. show me all the lastnames LIKE 'cronkyte'
should return cronkite... according to which SQL? 92, 99 probly not. You appear to need a phonetic search. LIKE does not work like that. Phonetic searches are rather complex and highly depend on the language you search for. As long as you are not able to specify the used language somewhere, its impossible to work as expected.
Regards Tino Wildenhain
participants (3)
-
Andreas Jung -
Joel Jensen -
Tino Wildenhain