Changeset 2625 for branches/release-40/lib/MT/ObjectDriver/Driver/DBI.pm

Timestamp:

06/20/08 09:02:09 (18 months ago)

Author:

fumiakiy

Message:

Removed hard-coded SQL statement and pass select list to SQL class. This is mainly for enterprise database drivers to generate SQL statements correctly. BugId:79817

Files:

• branches/release-40/lib/MT/ObjectDriver/Driver/DBI.pm (modified) (1 diff)

branches/release-40/lib/MT/ObjectDriver/Driver/DBI.pm

@@ -257 +257 @@
     }
     $stmt->select([]);
-    my $sql = "SELECT $select\n" . $stmt->as_sql;
+    $stmt->select_map({});
+    $stmt->select_map_reverse({});
+    $stmt->add_select($select => $select);
+    my $sql = $stmt->as_sql;
     $driver->select_one($sql, $stmt->bind);
 }