View | Details | Raw Unified | Return to bug 7977
Collapse All | Expand All

(-)a/tools/quotes/quotes_ajax.pl (-10 / +2 lines)
Lines 88-102 else { Link Here
88
    my $iTotalRecords = '';
88
    my $iTotalRecords = '';
89
    my $sth = '';
89
    my $sth = '';
90
90
91
    if (my $filter = $params->{'sSearch'}) {
91
    $iTotalRecords = $dbh->selectrow_array('SELECT count(*) FROM quotes;');
92
        # This seems a bit brute force and ungraceful, but it provides a very general, simple search on all fields
92
    $sth = $dbh->prepare("SELECT * FROM quotes;");
93
        $iTotalRecords = $dbh->selectrow_array("SELECT count(*) FROM quotes WHERE id LIKE %?% OR source LIKE %?% OR text LIKE %?% OR timestamp LIKE %?%;",undef,($filter, $filter, $filter, $filter));
94
        $sth = $dbh->prepare("SELECT * FROM quotes;");
95
    }
96
    else {
97
        $iTotalRecords = $dbh->selectrow_array('SELECT count(*) FROM quotes;');
98
        $sth = $dbh->prepare("SELECT * FROM quotes;");
99
    }
100
93
101
    $sth->execute();
94
    $sth->execute();
102
    if ($sth->err) {
95
    if ($sth->err) {
103
- 

Return to bug 7977