View | Details | Raw Unified | Return to bug 6030
Collapse All | Expand All

(-)a/misc/cronjobs/overdue_notices.pl (-3 / +2 lines)
Lines 404-411 foreach my $branchcode (@branches) { Link Here
404
404
405
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
405
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
406
406
407
    my $sth2 = $dbh->prepare( <<"END_SQL" );
407
    my $sth2 = $dbh->prepare( <<'END_SQL' );
408
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
408
SELECT biblio.title as "biblio.title",  biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
409
  FROM issues,items,biblio, biblioitems
409
  FROM issues,items,biblio, biblioitems
410
  WHERE items.itemnumber=issues.itemnumber
410
  WHERE items.itemnumber=issues.itemnumber
411
    AND biblio.biblionumber   = items.biblionumber
411
    AND biblio.biblionumber   = items.biblionumber
412
- 

Return to bug 6030