SF.net SVN: ledger-smb:[2370] trunk/LedgerSMB/RP.pm

[..hidden..]

Revision: 2370
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2370&view=rev
Author:   einhverfr
Date:     2008-10-14 20:26:40 +0000 (Tue, 14 Oct 2008)

Log Message:
-----------
Correcting handling of blank inputs.

Modified Paths:
--------------
    trunk/LedgerSMB/RP.pm

Modified: trunk/LedgerSMB/RP.pm
===================================================================
--- trunk/LedgerSMB/RP.pm	2008-10-14 18:35:10 UTC (rev 2369)
+++ trunk/LedgerSMB/RP.pm	2008-10-14 20:26:40 UTC (rev 2370)
@@ -1453,6 +1453,12 @@
         my $datefrom = $dbh->quote($form->{fromdate});
         my $dateto = $dbh->quote($form->{todate});
 	my $safe_project_id = $dbh->quote($project_id);
+        if ($datefrom eq "''") {
+            $datefrom = "NULL";
+        }
+        if ($dateto eq "''") {
+            $dateto = "NULL";
+        }
         $query = "SELECT c.id AS chart_id, c.accno, c.description, c.contra, 
                                 c.category,
                                 SUM(CASE WHEN ac.transdate < $datefrom


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.