[Openinteract-dev] fetch_count patch for SPOPS::DBI.pm

[Ray Z. <rz...@co...>]

Chris,

Here's a small patch which allows you to do joins safely in fetch_count().

--- DBI.pm.orig Tue Apr  9 16:06:16 2002
+++ DBI.pm      Tue Apr  9 16:10:21 2002
@@ -369,7 +369,7 @@

  sub fetch_count {
      my ( $class, $p ) = @_;
-    $p->{select} = [ $class->id_field ];
+    $p->{select} = [ $class->table_name . '.' . $class->id_field ];
      my $sth = $class->_execute_multiple_record_query( $p );
      my $row_count = 0;
      while ( my $row = $sth->fetch ) {

-- 
  Ray Zimmerman  / e-mail: rz...@co... / 428-B Phillips Hall
   Sr Research  /   phone: (607) 255-9645  /  Cornell University
    Associate  /      FAX: (815) 377-3932 /   Ithaca, NY  14853