Help with keyword search

[dnjacobsen]

I need help, I can search SQLite for multiple keywords allright but what I need is to have an exact match based on whatever number of keywords that are used. May be 2 keywords or may be 3 keywords.

Example:

Search: fox crooked fence

The fox jumped the crooked old fence.

tblRS = SQLite.QueryToTable(db, "Select Long_Desc from Desc")
tbl_Search = DelimitedStringToTable2(Input.GetText("Input1"), " ");

	if tblRS and tblRS.Rows then
		for i,v in tblRS.Data do
			for index1, word in tbl_Search do
				WordFound = nil;
				WordFound = String.Find(tblRS.Data[i]["Long_Desc"], word, 1, false);
				if WordFound > -1 then
					ListBox.AddItem("ListBox1", tblRS.Data[i]["Long_Desc"], "");
				end
			end
		end
	end
end

[Derek]

I think the problem is being caused by the fact that you are mixing them up here.
The fox jumped over the lazy dog!
Surely the crooked fence was somewhere along the crooked mile?

[sorry, couldnt resist]

[dnjacobsen]

Could also be a crooked problem, no one seems to be able to straighten it out.

[dnjacobsen]

Isn't there anybody that can help me with this.

If it's not possible at least aknowledge it, I feel that this is being ignored.

I have posted it on this board and on the am6 6.0 board with no response whatsoever.

[Derek]

---------------