Problem with text search

Classic Servoy
1

I have a customer´s table with column customer_name and I need get a foundset with all customers whose name is between 2 values : customer_from and customer_to (both global text variables filled using a valuelist on this table), so I do the following :
var customers = databaseManager.getFoundSet(‘infocom’,‘customers’)
customers.find()
customers.customer_name=‘#’+ globals.customer_from+’ …'+globals.customer_to
if (customers.search() == 0)

I have found that, when globals.customer_from contains a dot character, the search fails and returns 0 records; I suposse it is related to the 3 dots used for indicate a range of information.

We can not ask the user to use customer names without dots inside it.

ANyone faced this situation ? Any workaround suggested ?

2

Achiary,

What version of Servoy do you use?

I tried in Servoy 5.2 and a search on ‘#a.aa…bbb’ does a case-insentive search between ‘a.aa’ and ‘bbb’ as expected.

Rob

3

Rob,

I am using 5.1.2 with Sybase.

4

Achiary,

Text search has not changed from 5.1 to 5.2.

Print out the actual search string for debugging.
Or try a small example with fixed text, the dot should not be the problem.

Rob