Thunderstone Support Forums

We have data of the form

myname@aol.com
yourname@aol.com

and want to do searches like

'*aol.com'
to get both the hits.

We have set qminprelen set to 0, still we could not get the search to return hits.

The data we are testing on is a 15 record table.

we also have allinear='on'.

ANy help would be great.
thanks!!
P.S. also, if we want to search for * literally, what is the escape character? \* does not seem to work.

Thanks.
It is true for us also if I don't have index, the search works.
But, as soon as we create an index on that field, the search does not work. I also figured out that the problem is due to the index expression. Our expressions are,

set delexp=0;set addexp='[\alnum\-#&*@.]{1,30}';set keepnoise='on';set addexp='\alnum{1,99}';set addexp='>>\alpha{1,50},=\alpha{1,50}'

we put in the [\alnum\-#&*@.]{1,30} to get terms like 400- and 400-135B.
and this is the expression that is breaking the *casecentral.com.

Any reason why?

Thanks for all the help!!

Remove the asterisk (*) from your index expression. That confuses the index at search time, because asterisk is a reserved character in search terms.