From 79048289d089ef030e6324d5fa6215e8fb95e713 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 11 Sep 2012 13:06:27 -0400 Subject: [PATCH] minor modification --- change_reports_owner.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/change_reports_owner.pl b/change_reports_owner.pl index 8065af8..758d807 100755 --- a/change_reports_owner.pl +++ b/change_reports_owner.pl @@ -121,7 +121,7 @@ if (defined($email1) && defined($email2)) { $sth = $dbh->prepare("$update_schedule"); $sth->execute($user_id2, $email1, $email2, $user_id1); } elsif (defined($email2)) { - my $update_schedule = qq/UPDATE reporter.schedule SET runner = ?, email = email || ? WHERE runner = ? AND complete_time IS NULL/; + my $update_schedule = qq/UPDATE reporter.schedule SET runner = ?, email = email || ' ' || ? WHERE runner = ? AND complete_time IS NULL/; $sth = $dbh->prepare("$update_schedule"); $sth->execute($user_id2, $email2, $user_id1); } else { -- 2.11.0