chronister

Banging my head against the wall with ExecuteSql

Discussion created by chronister on Mar 28, 2014
Latest reply on Mar 28, 2014 by erolst

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

Outcomes