What I am trying to do is get a recordcount of a query but avoiding the limit by 100.This is what I thought of but its returning a -1 and I cannot understand why.
ok what I did is did a same query for example
sql = "select * from table1 where match(column1) against('products') order by id limit by 100"
sql2 = "select * from table1 where match(column1) against('products') order by id"
and then where I want the count to be is repsone.write"RS2.recordcount"
this will do the same query but without the limit to get the true couint but for some reason I get a -1.Why would that be?