A belated reply:
>That would be good. What would *really* be good was if you could have
>words indexed several ways, i.e.
>
>Smith-Watson
>
>would be found by searching for
>
>"Smith"
>or
>"Watson"
>or
>"Smith-Watson"
If the future SET OF WORD DELIMITERS really is a set, and if it's applied BOTH to the index AND to the user's query, the above will work.
Meanwhile, just create a second field that converts "-" (and any other chars that should behave the same way) into " ", and index that. (I can't remember if you can do this with a method; if not, just do it using RB/C/AppleScript/Frontier/whatever.) And
, apply the same transformation on the user's text when you build the SQL.
Scott
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2001 Scott Lawton |
