Turn off Iterative Search for one Table?

Support, Tips and Mods for Matt Navarre's SearchResults technique.
Posts: 40
Joined: Wed Oct 06, 2010 6:49 pm
PostPosted: Thu Oct 11, 2012 1:54 am
I have one table (Table03 to be exact) where I'd only want to find (for example) John Doe... I would not want John Smith or Jane Doe or even Johnny Doe in the results.
I do not want my users to be required to put in search modifiers like = or ==
The fields searched in the Table03 are
NameFirst
NameMiddle
NameLast

Any assistance is always appreciated

Thanks,
Max
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Thu Oct 11, 2012 9:15 am
Hi,

In the script "Search - Iterate" there is an IF clause that begins with the comment

#If data type is text or list, build array of search terms and try them all

This is the part that breaks the search string into individual words to use as criteria. If you disable the whole IF block, then that will prevent that part from happening.

hth,
Jason

Return to fmSearchResults

Who is online

Users browsing this forum: No registered users and 2 guests

(855) SEEDCODE
[email protected]
Follow us: