Search Operator in 1FS

Company Name:
Address:
City: State: Zip:
 
select opr.cho_id, opr.cho_name as companyName, opr.cho_address as address, opr.cho_address2 as address2, opr.cho_city as city, opr.cho_state as state, opr.cho_zipcode as zipcode from tbl_CHO_Operators opr where 1 = 1 and left( opr.cho_zipCode, 3 ) = and opr.cho_state = and opr.cho_city = and opr.cho_name =

Name: IGNORED
 Address: ALWAYS IGNORED
City: IGNORED
 State: IGNORED

Results Found: #qmd_operatorLookup.recordCount#

 queryAddColumn( qmd_operatorLookup, "stdAddress", "varchar", ArrayNew(1) ); queryAddColumn( qmd_operatorLookup, "companyNameEditDistance", "integer", ArrayNew(1) ); queryAddColumn( qmd_operatorLookup, "addressEditDistance", "integer", ArrayNew(1) );

#url.companyStreet#

#_srcStdStreet#

Parsed Original Street Name: #_srcStdStreet#

querySetCell( qmd_operatorLookup, "stdAddress", _fseStdStreet, qmd_operatorLookup.currentRow ); querySetCell( qmd_operatorLookup, "companyNameEditDistance", _companyNameDistance, qmd_operatorLookup.currentRow ); querySetCell( qmd_operatorLookup, "addressEditDistance", _addressDistance, qmd_operatorLookup.currentRow ); StructDelete( variables, "matcher" ); StructDelete( variables, "fseStreetParser" ); StructDelete( variables, "srcStreetParser" ); select * from qmd_operatorLookup where ( addressEditDistance <= 10 and companyNameEditDistance <= 10 ) ---> order by companyNameEditDistance, addressEditDistance

Results Found: #qmd_operatorLookup.recordCount#