@@ -, +, @@ --- C4/Utils/DataTables/Members.pm | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) --- a/C4/Utils/DataTables/Members.pm +++ a/C4/Utils/DataTables/Members.pm @@ -84,12 +84,12 @@ sub search { my $orderby = dt_build_orderby($dt_params); my $limit; - if(defined $dt_params->{iDisplayStart} and defined $dt_params->{iDisplayLength}) { - # In order to avoir sql injection - $dt_params->{iDisplayStart} =~ s/\D//g; - $dt_params->{iDisplayLength} =~ s/\D//g; - $limit = "LIMIT $dt_params->{iDisplayStart},$dt_params->{iDisplayLength}"; - } + # In order to avoid sql injection + $dt_params->{iDisplayStart} =~ s/\D//g; + $dt_params->{iDisplayLength} =~ s/\D//g; + $dt_params->{iDisplayStart} //= 0; + $dt_params->{iDisplayLength} //= 20; + $limit = "LIMIT $dt_params->{iDisplayStart},$dt_params->{iDisplayLength}"; my $query = join( " ", --