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

(-)a/misc/cronjobs/overdue_notices.pl (-3 / +2 lines)
Lines 388-395 foreach my $branchcode (@branches) { Link Here
388
388
389
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
389
    $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;
390
390
391
    my $sth2 = $dbh->prepare( <<"END_SQL" );
391
    my $sth2 = $dbh->prepare( <<'END_SQL' );
392
SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
392
SELECT biblio.title as "biblio.title",  biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue
393
  FROM issues,items,biblio, biblioitems
393
  FROM issues,items,biblio, biblioitems
394
  WHERE items.itemnumber=issues.itemnumber
394
  WHERE items.itemnumber=issues.itemnumber
395
    AND biblio.biblionumber   = items.biblionumber
395
    AND biblio.biblionumber   = items.biblionumber
396
- 

Return to bug 6030