Changeset 10130

Timestamp:

Nov 21, 2006, 6:18:05 PM (19 years ago)

Author:

jhoblitt

Message:

handle NULL psTime objections when generation SQL conditional stmts

File:

• trunk/psLib/src/db/psDB.c (modified) (2 diffs)

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.115 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-11-20 20:57:51 $
+ *  @version $Revision: 1.116 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-11-22 04:18:05 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
@@ -1754 +1754 @@
         break;
     case PS_DATA_TIME: {
-            psString timeStr = psTimeToISO(item->data.V);
-            psStringAppend(&query, "%s %s '%s'", itemName, op, timeStr);
-            psFree(timeStr);
+            if (item->data.V) {
+                psString timeStr = psTimeToISO(item->data.V);
+                psStringAppend(&query, "%s %s '%s'", itemName, op, timeStr);
+                psFree(timeStr);
+            } else {
+                psStringAppend(&query, "%s %s NULL", itemName, op);
+            }
 
             break;