From 019791c5ed7c464b6fbf6d2768c71a2f56dbdf79 Mon Sep 17 00:00:00 2001 From: Sophie Meynieux Date: Mon, 10 Sep 2012 17:45:34 +0200 Subject: [PATCH] Bug 6030 followup : Specify "biblio.title" as a column name to differentiate from borrowers.title Content-Type: text/plain; charset="utf-8" Signed-off-by: wajasu Signed-off-by: Kyle M Hall --- misc/cronjobs/overdue_notices.pl | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/misc/cronjobs/overdue_notices.pl b/misc/cronjobs/overdue_notices.pl index 9f9b4bc..2b8f368 100755 --- a/misc/cronjobs/overdue_notices.pl +++ b/misc/cronjobs/overdue_notices.pl @@ -404,8 +404,8 @@ foreach my $branchcode (@branches) { $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address; - my $sth2 = $dbh->prepare( <<"END_SQL" ); -SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue + my $sth2 = $dbh->prepare( <<'END_SQL' ); +SELECT biblio.title as "biblio.title", biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue FROM issues,items,biblio, biblioitems WHERE items.itemnumber=issues.itemnumber AND biblio.biblionumber = items.biblionumber -- 1.7.2.5