Android Question SQL query question

[anaylor01]

The below query isn't returning anything. How can I get it to return something?

If  SQL1.ExecQuerySingleResult("SELEct  ifnull(COUNT(*),'0') FROM  GamePlay GROUP BY   teamscore, teamround HAVING    COUNT(*) > 1") > 1 Then

 

[LWGShane]

Maybe this?

Dim Score As Int
Int = SQL1.ExecQuerySingleResult("Query")
If Score > 1 Then
'Your logic here.
End If

 

[somed3v3loper]

Maybe this?

Dim Score As Int
Int = SQL1.ExecQuerySingleResult("Query")
If Score > 1 Then
'Your logic here.
End If

 Score = SQL1.ExecQuerySingleResult("Query")

 

[anaylor01]

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.

 

[anaylor01]

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

 

[sorex]

try

SELEct COUNT(*) FROM GamePlay GROUP BY teamscore, teamround

SELECT count(*) from tbltemplate where timeleft=0

 

[anaylor01]

Thanks.