- warn "# SQL:\n$sql_select\n", $sql_where ? $sql_where : '-- no where', "\n# DATA: ",dump( @values );
- my $sth = $dbh->prepare( $sql_select . $sql_where . " LIMIT $max_results" ); # XXX remove limit?
+ my $sql
+ = $sql_select
+ . $sql_where
+# . ( $objectclass =~ m{person}i ? " LIMIT $max_results" : '' ) # add limit just for persons
+ ;
+
+ warn "# SQL:\n$sql\n# DATA: ",dump( @values );
+ my $dbh = DBI->connect_cached($dsn . $database, $user,$passwd, { RaiseError => 1, AutoCommit => 1 }) || die $DBI::errstr;
+ my $sth = $dbh->prepare( $sql );