Allowing Percent in Search

[rgerz]

I have a search that works perfectly, except that there are some values in a column that are used in the comparison that contain a percent sign "EO %". The search is actually matching "EO " against "EO " which isn't what I need. How do I keep the percent sign as part of the value?

Code: Select all

      forms.inst_tests.controller.find();
      forms.inst_tests.test_code = testcode;
      var recordcount = forms.inst_tests.controller.search();


Cheers,
Ray

[rgerz]

I solved issue with:

Code: Select all

testcode = utils.stringReplace(testcode,"%","\\%");


Cheers!
Ray