Bob Sneidar wrote: > Yes, but the original question was about whether or not it could be > done with a single statement. Also I am not a big fan of full text > searches the way they are implemented typically. For instance, on our > copier vendor's websites they of course have searches, but what I end > up with are 10,000 hits and almost none of them relevant. This is > because they are not ranked, and the ranking makes all the difference > in the world. > > My method does not rank of course, but it is a quick one liner that > gets the job done (unless you have to build the query on the fly in a > repeat loop).
SQLite's FTS is described as providing ranking. Maybe they were using an older version, or not using the full API?
-- Richard Gaskin Fourth World Systems Software Design and Development for the Desktop, Mobile, and the Web ____________________________________________________________________ ambassa...@fourthworld.com http://www.FourthWorld.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode