Hi all, This is a weird problem that I will try to explain in my own way. I construct my search query by including all possible indexed fields and using the wildcard if the user hasn't provided data for a field. Eg if the indexed fields are "surname", "first_name" and "second_name" and the user has only provided data in the surname and first_name fields the query would be: "surname:Smith AND first_name:John AND second_name:*" This seems to work fine unless I use a single character 'a' exclusively in any, some or all of the fields. So say I enter an 'a' in surname with the query being: "surname:a AND first_name:* AND second_name:*" I get a result containing every record from my data set. If for example I use any other character (or multiple characters) in the surname field such as: "surname:b AND first_name:* AND second_name:*" I get no results, which I assume is correct because I have no people in my data set with a surname of "b". This same problem applies to any of the indexed fields. Here's some more examples: "surname:a AND first_name:a AND second_name:a" gives every record "surname:a AND first_name:a AND second_name:*" gives every record "surname:a AND first_name:b AND second_name:*" gives no records which I expect "surname:a" gives no records which I expect Any idea's what might be going on here?
on 2008-09-23 09:39