Jython: Displaying the result of a query

@LOADID

Earlier if we wanted to display a result of a query after the validate (for example when it does not balance)

I would set up a query, execute it and just display it with a simple message

    Set rs = DW.DataAccess.farsFireHose(strSQL, 1)

        total = CDbl(rs.fields("AMOUNT").value)

        RES.PlngActionType = 2

        RES.PstrActionValue = "WARNING - Ledger does not balance: " & Round(CDbl(total),2)

Im trying to do this like this, but its not working:

query = """declare @LOADID int

SET @LOADID= ?

Select IsNull(Sum(D.AMOUNT),0) AMOUNT FROM TDATASEG D

WHERE D.PARTITIONKEY = @LOADID"""

params=[str(fdmContext["LOADID"])]

rs=fdmAPI.executeDML(query, params, False)