| 
      
            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 | 
              -   | 
               | 
               |