Search and Single Character problems

HCL Domino Domino Forum
1

I have a database search that we are doing on the web. I build up my url depending on which fields have values in them. Here is an exerpt from my code:

q1 := @If(Query=“”;“”;“(”+Query+“)”);

q2 := @If(Surname=“”;“”;“[Surname]CONTAINS(”+Surname+“*)”);

This bit basically says that if there is something in the ‘query’ field do a general search against that text but if there is something in the ‘surname’ field then pass [Surname]CONTAINS(smit*). 99% of the time this works well but we have run into some problems with our Dutch friends. Four of our members of staff are named:

Van Rensburg

van Roon-Slaghuis

Van Rooyen, Y

van Rooyen, M

If I type ‘van r’ into the surname box it only brings back the first one, whereas if I type ‘van r’ into the general query box it brings back all four. Any idea what is going on and how to fix it ?

Thanks

Paul

2

Subject: Search and Single Character problems

try this

“[Surname]CONTAINS("”+Surname+“"*)”);