Browse Next Page Broken

Questions related to using nuBuilder Forte.

Browse Next Page Broken

Postby BoydG » Sat Feb 09, 2019 1:02 am

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?
BoydG
 
Posts: 15
Joined: Mon Dec 31, 2018 7:01 pm

Re: Browse Next Page Broken

Postby kev1n » Sat Feb 09, 2019 1:17 am

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)
kev1n
 
Posts: 198
Joined: Mon Oct 15, 2018 2:13 am

Re: Browse Next Page Broken

Postby BoydG » Sat Feb 09, 2019 1:34 am

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.
BoydG
 
Posts: 15
Joined: Mon Dec 31, 2018 7:01 pm


Return to General



cron