10 Replies Latest reply on Mar 28, 2014 6:45 PM by erolst

    Banging my head against the wall with ExecuteSql

    chronister

      Here is the statement.. .simple. I want to count the number of items where the field TaskStatus = True. I keep getting ? but have managed to get a 0 with the second version... please help lol

       

      ExecuteSQL ("SELECT COUNT(taskID) FROM ProjectTasks WHERE TaskStatus = "True" " ; "" ; "")

       

      ExecuteSQL ("SELECT COUNT(taskID) FROM ProjectTasks WHERE TaskStatus = ? " ; "" ; "True")

       

      Thanks,

       

      Nate