From 4a5a527bb93de287bdb63dcc7240c80a72bfc89a Mon Sep 17 00:00:00 2001 From: miker Date: Sun, 25 Jan 2009 17:17:41 +0000 Subject: [PATCH] restriction on non-real IDs git-svn-id: svn://svn.open-ils.org/ILS/trunk@11951 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/extras/fast-extract | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/extras/fast-extract b/Open-ILS/src/extras/fast-extract index 8ad32a5ed2..4c59642a2d 100755 --- a/Open-ILS/src/extras/fast-extract +++ b/Open-ILS/src/extras/fast-extract @@ -47,8 +47,8 @@ my $dsn = "dbi:" . $db_driver . ":dbname=" . $db_name .';host=' . $db_host . ';p my $dbh = DBI->connect($dsn,$db_user,$db_pw, {AutoCommit => 1, pg_enable_utf8 => 1, RaiseError => 1}); -my $SQL = 'SELECT id FROM biblio.record_entry'; -$SQL .= " WHERE edit_date > '$after'" if ($after); +my $SQL = 'SELECT id FROM biblio.record_entry WHERE id > 0'; +$SQL .= " AND edit_date > '$after'" if ($after); my $ids = $dbh->selectcol_arrayref($SQL); -- 2.11.0