Allowing Percent in Search

Classic Servoy
1

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?

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

Cheers,
Ray

2

I solved issue with:

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

Cheers!
Ray