ambassador at fourthworld.com
Tue Jan 14 17:05:23 EST 2020
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?
Fourth World Systems
Software Design and Development for the Desktop, Mobile, and the Web
Ambassador at FourthWorld.com http://www.FourthWorld.com
More information about the use-livecode