From d7958942a691a719be4d3433b5a24817c8646f9a Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Sun, 20 Feb 2005 16:02:06 +0000 Subject: Bug 280502: Replace "INTERVAL" with Bugzilla::DB function call Patch By Tomas Kopal r=mkanat, a=justdave --- Bugzilla/Search.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Bugzilla/Search.pm') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 82cbb9aa6..a1058fbe5 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -906,7 +906,7 @@ sub init { $unitinterval = 'YEAR'; } my $cutoff = "DATE_SUB(NOW(), " . - "INTERVAL $quantity $unitinterval)"; + $dbh->sql_interval("$quantity $unitinterval"); my $assigned_fieldid = &::GetFieldID('assigned_to'); push(@supptables, "LEFT JOIN longdescs comment_$table " . "ON comment_$table.who = bugs.assigned_to " . -- cgit v1.2.3-24-g4f1b