From 4b6c3abc224a7bd10eb257ad2ab203fa0f94d7b0 Mon Sep 17 00:00:00 2001 From: hdl Date: Fri, 3 Feb 2006 16:05:27 +0000 Subject: [PATCH] Adding a query trace for overdue.pl (seems that some people donot have ALL the results they would like to get) But I tested and get the proper results. So Waiting for deeper tests. --- overdue.pl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/overdue.pl b/overdue.pl index cb1eaa09e1..4ceba0709c 100755 --- a/overdue.pl +++ b/overdue.pl @@ -131,14 +131,13 @@ $strsth.=" && issues.branchcode = '".$branchfilter."' " if($branchfilter) ; # my $itemtypefilter=$input->param('itemtype'); # my $borflagsfilter=$input->param('borflags'); # my $branchfilter=$input->param('branch'); - if ($order eq "borrower"){ $strsth.=" order by borrower,date_due " ; } else { $strsth.=" order by date_due,borrower "; } my $sth=$dbh->prepare($strsth); -# warn "".$strsth; +warn "overdue.pl : query string ".$strsth; $sth->execute(); my @overduedata; -- 2.39.5