Sl_eob_search name search

redlettertech wrote on Thursday, July 09, 2009:

When you use the name search feature on the sl_eob_search.php page it does not return any results if you include a first name.  For example typing smith, john will not return any results, but smith will return 120 smiths including smith, john.  Searching S-T also returns smith, john along with all the other names that begin with s to t.  This makes posting of EOB items longer when the user has to wait for the list to be returned then find the name they are looking for in a long list. 

Does anyone have a fix for this search issue. 

redlettertech wrote on Saturday, July 11, 2009:

The fix is to edit sl_eob_search.php version 1.30 and scroll to line 538 to change the pfname variable $matches[1] to $matches[2]

As shown below:
$where .= “p.lname LIKE '” . $matches[1] . “%’ AND p.fname LIKE '” . $matches[2] . “%’”;

sunsetsystems wrote on Monday, July 13, 2009:

Thanks! I have applied this fix in CVS.

Rod
www.sunsetsystems.com