Limitation to 100 results ?

[carsten.harnisch1]

I am using the API. It seems to me that n_gettsql only returns the first 100 results, although there are definetly more (also n_getindexcount is reporting more than 250).
Is this a config-var or am I doing something wrong here ?

[John]

You are probably using likep. There is a setting, likeprows, which controls how many of the best results are returned. Typically with LIKEP you are looking for the best result, which should be in the first 100.

[carsten.harnisch1]

Right, I am using likep. Thanks for the help.

[carsten.harnisch1]

Well I tried doing :

sprintf(szBuffer, "set likeprows=%d;", nMaxResults);
ret = n_texis(se, szBuffer);

(where nMaxResults holds the number of rows to return).

But I still getting only 100 results back ! Any special place to do this or any side effects ?

[John]

It needs to be done before the LIKEP query, and using the same SERVER pointer (se). Since you are using n_gettsql, you might want to use n_dotsql() instead of n_texis(), and use the same TSQL pointer. What is the return from n_texis, and do you get any messages? Also you might try with tsql the same thing to make sure there are more than 100 results.

[carsten.harnisch1]

ok, n_dotsql() did the job ! Thanks.