[Andro-hacker] SF.net SVN: andro:[897] trunk/andro/application/androBuild.php

[<dor...@us...>]

Revision: 897
          http://andro.svn.sourceforge.net/andro/?rev=897&view=rev
Author:   dorgan1983
Date:     2008-11-20 22:39:07 +0000 (Thu, 20 Nov 2008)

Log Message:
-----------
fix to sum with offset and limit so that null does not get returned.

Modified Paths:
--------------
    trunk/andro/application/androBuild.php

Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php	2008-11-20 15:24:35 UTC (rev 896)
+++ trunk/andro/application/androBuild.php	2008-11-20 22:39:07 UTC (rev 897)
@@ -4463,7 +4463,7 @@
     $sqlints
     IF --COALESCE--MATCH-- THEN
         UPDATE $table_par SET $column_par=(
-            SELECT SUM(x1.$column_chd) FROM (
+            SELECT COALESCE(SUM(x1.$column_chd),0) FROM (
                 SELECT $column_chd
                   FROM $table_chd
                  WHERE --MATCH--CHD--


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