SQL sum issue

[madman411]

I'm trying to sum a set of related records that only contain a specific value:

ExecuteSQL (
"SELECT
  
SUM (Subtotal)
FROM
  LineItems
WHERE
  
id = InvoiceID AND
  
sFlag = 1"
; "" ; "" )

but I'm getting a null result.

The Subtotal field is a calculated field.

Ideas?

[eos]

Try

ExecuteSQL ( "
  SELECT SUM (Subtotal)
  FROM LineItems 
  WHERE id = ? AND sFlag = 1
  " ; "" ; "" ; InvoiceID
)