[Koha-cvs] koha/export marc-time.pl [rel_2_2]

[Tumer Garip]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_2_2
Changes by:     Tumer Garip <address@hidden>    06/04/12 20:45:40

Modified files:
        export         : marc-time.pl 

Log message:
        SQL syntax corrected

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/koha/export/marc-time.pl.diff?only_with_tag=rel_2_2&tr1=1.1.2.1&tr2=1.1.2.2&r1=text&r2=text

Patches:
Index: koha/export/marc-time.pl
diff -u koha/export/marc-time.pl:1.1.2.1 koha/export/marc-time.pl:1.1.2.2
--- koha/export/marc-time.pl:1.1.2.1    Thu Apr  6 07:28:01 2006
+++ koha/export/marc-time.pl    Wed Apr 12 20:45:40 2006
@@ -19,11 +19,11 @@
        my $dbh=C4::Context->dbh;
        my $sth;
        if ($start_bib && $end_bib) {
-               $sth=$dbh->prepare("select biblionumber from biblioitems where 
timestamp >=? and timestamp <=? order by biblionumber");
-               $sth->execute($start_bib,$end_bib);
+               $sth=$dbh->prepare("select biblionumber from biblioitems where 
timestamp >='$start_bib' and timestamp <='$end_bib' order by biblionumber");
+               $sth->execute();
        } elsif ($start_bib ) {
-               $sth=$dbh->prepare("select biblionumber from biblioitems where 
timestamp >=?  order by biblionumber");
-               $sth->execute($start_bib);
+               $sth=$dbh->prepare("select biblionumber from biblioitems where 
timestamp >='$start_bib'  order by biblionumber");
+               $sth->execute();
        }else {
                $sth=$dbh->prepare("select biblionumber from biblioitems order 
by biblionumber");
                $sth->execute();