[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 <tgarip1957 at savannah.gnu.org>	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();