Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Knop_grid header and footer show incorrect maxrecords with -sql #98

Open
phillipsIT opened this issue Dec 20, 2013 · 1 comment
Open
Labels
Milestone

Comments

@phillipsIT
Copy link

Demo lib_customer_list.inc

page_skiprecords($maxrecords); // build search params // first set some basic search parameters var('searchparams'=array(-maxrecords=$maxrecords, -skiprecords=$skiprecords)); // use -uselimit only for non-filemaker data sources !$d->'isfilemaker' ? $searchparams->insert(-uselimit); // then add sort parameters, if any $searchparams -> merge($list -> sortparams); // then add search parameters, if any $searchparams -> merge($list -> quicksearch); // get list of records //$d -> select($searchparams); local(sql = 'SELECT * FROM `knopdemo`.`customer` LIMIT ' + $skiprecords + ',' + $maxrecords) $d -> select(-sql=#sql) ``` /\* Both the header and footer show the incorrect maxrecords of 50 when it should show 20. /* ``` // clear any record locks $s_user -> clearlocks; ``` ?>
@stevepiercy
Copy link
Member

This is an issue with knop_grid->renderfooter. @jolle-c do you have a fix available? If so, I'd like to avoid duplicating efforts to fix this bug. This works fine in Knop for Lasso 8.

@stevepiercy stevepiercy added this to the 0.2 milestone Jul 11, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants