Multiple Where conditions in ExecuteSQL

[Bill Doerrfeld]

I'd like to use ExecuteSQL to get a count on all records due today whose "Status" is not "Active".

The following code returns the count on all records due today. How do I add an additional WHERE condition for Status != Active?

ExecuteSQL(

" SELECT COUNT ( ID )

FROM ExecuteSQL

WHERE DueDate = ? "

; "" ; "" ; Get(CurrentDate)

)

I know how to achieve this with "standard" SQL but am stumbling with this ExecuteSQL implementation. Thanks.

[Bill Doerrfeld]

Nevermind. Went out for a short walk and the answer came to me which is...

ExecuteSQL(

" SELECT COUNT ( ID )

FROM Item

WHERE Due = ? AND Status = ? "

; "" ; "" ; Get(CurrentDate) ; "Active"

)