I have to ask. What is the point of the IFNULL function if it doesn't do anything. I have tired it with integers, strings. I can't get it to return anything.
I have an empty table and I need to check to see if it is empty. But any SQL I write just gets the java.lang.NumberFormatException: Invalid double: "null" error. There should be some way to do this with a simple statement like below.
if SQL1.ExecQuerySingleResult("SELECT sum(ifnull(timeleft,'0')) from tbltemplate") > "0" Then