Page 1 of 1

Browse Next Page Broken

Posted: Fri Feb 08, 2019 4:32 pm
by BoydG
Having an issue with the Browse page.
When there's more than 1 page and I click the arrow to go to the 2nd page, it shows the same data as the first page.
I've figured out that any time a SQL browse query contains a where clause, this happens.

Suggestions?

Re: Browse Next Page Broken

Posted: Fri Feb 08, 2019 4:47 pm
by kev1n
Hi,

I don't see this kind of issue with pagination here.

e.g. Browse SQL:

Code: Select all

SELECT * FROM mytable
WHERE table_field = 'something'
When I click the arrow to navigate to the 2nd page, different records are shown.

(using the latest from Sourceforge, Standalone version, not Wordpress Plugin)

Re: Browse Next Page Broken

Posted: Fri Feb 08, 2019 5:04 pm
by BoydG
Thanks for the reply.
After further testing, I noticed I ended the SQL statement with a ;
When I took the semi-colon off, it started working.