IfNot CInt(TotalPages)= CInt(RSPage)Then
If TotalRecords < Max Then
PageSwitch = False
PageSwitch = True
I also need it to work with the following SQL but have failed in all attempts so far.
"SELECT *, MATCH (url,description,name) AGAINST ('" & Search & "' IN BOOLEAN MODE) AS score FROM tblsearch WHERE Active=-1 AND MATCH (url,description,name) AGAINST ('" & Search & "' IN BOOLEAN MODE) ORDER BY name ASC LIMIT " & Offset & "," & Max
The MATCH command seems to be causing a problem when combined with the COUNT(*) feature,
The String above works fine on its own, but not with COUNT(*).