diff options
| author | louise <louise> | 2009-07-01 12:52:41 +0000 |
|---|---|---|
| committer | louise <louise> | 2009-07-01 12:52:41 +0000 |
| commit | e1fbe927ce523c4933114cc9dbae58b7701a02ec (patch) | |
| tree | eaa325b971ad62b50d56ca2b1085b9108805fc20 | |
| parent | 828efae373e5b8be8956fa35dd6fb38c819dfbd8 (diff) | |
Fixed syntax error
| -rw-r--r-- | perllib/Problems.pm | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/perllib/Problems.pm b/perllib/Problems.pm index 94df501fd..f34e4af9b 100644 --- a/perllib/Problems.pm +++ b/perllib/Problems.pm @@ -6,7 +6,7 @@ # Copyright (c) 2008 UK Citizens Online Democracy. All rights reserved. # Email: matthew@mysociety.org; WWW: http://www.mysociety.org/ # -# $Id: Problems.pm,v 1.14 2009-07-01 09:44:20 louise Exp $ +# $Id: Problems.pm,v 1.15 2009-07-01 12:52:41 louise Exp $ # package Problems; @@ -213,7 +213,8 @@ sub problems_matching_criteria{ sub fixed_in_interval { my ($start_date, $end_date) = @_; - my $criteria = "state='fixed' and date_trunc('day', lastupdate)>=$start_date and date_trunc('day',lastupdate)<=$end_date"; + my $criteria = "where state='fixed' and date_trunc('day',lastupdate)>='$start_date' and +date_trunc('day',lastupdate)<='$end_date'"; return problems_matching_criteria($criteria); } |