https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1707

--- Comment #7 from M. Tompsett <[email protected]> ---
Comment on attachment 57068
  --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=57068
Bug 1707: Do not return more than 100 patrons matching the attributes search

Review of attachment 57068:
 --> 
(https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=1707&attachment=57068)
-----------------------------------------------------------------

::: C4/Members/Attributes.pm
@@ +152,4 @@
>  JOIN borrower_attribute_types USING (code)
>  WHERE staff_searchable = 1
>  AND (} . join (" OR ", map "attribute like ?", @$filter) .qq{)};
> +    $query .= q{ LIMIT ?} if $limit;

LIMIT is a MySQLism.
Perhaps DBIx would be a good way to get around this?
Not that I know how to do it, but this looks like a good place to start:
http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#rows

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to