Changeset 10132

Timestamp:

Nov 21, 2006, 6:34:40 PM (19 years ago)

Author:

jhoblitt

Message:

compare NULL psTimes with "IS" instead of "="

File:

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

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.116 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-11-22 04:18:05 $
+ *  @version $Revision: 1.117 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-11-22 04:34:40 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
@@ -1758 +1758 @@
                 psStringAppend(&query, "%s %s '%s'", itemName, op, timeStr);
                 psFree(timeStr);
+            } else if (strstr(op, "=")) {
+                psStringAppend(&query, "%s IS NULL", itemName);
             } else {
-                psStringAppend(&query, "%s %s NULL", itemName, op);
+                psError(PS_ERR_UNKNOWN, true, "NULL psTime can't be compared with any operator other than '=='");
+                psFree(itemName);
+                return NULL;
             }