forums.smartfoxserver.com

Having an issue with a select statement:

var sql = "SELECT AVG(total) AS averageTotal FROM Table"
var queryRes = dbase.executeQuery(sql);
var tempRow = queryRes.get(0);
var theAverage = tempRow.getItem("averageTotal")

theAverage returns null.

I can do a select that returns 1 numeric result without any problem. However, I cannot do an aliased result set in any way I have tried.

Any suggestions or thoughts?

HK

I didn't have time to test the problem yet but I can suggest a couple of tests:

1 -> trace the size of the returned array. what does it say?

2-> Try calling the executeQuery method like this: This will return an array of rows, where each row is indexed by numbers starting from index 1.
So now you can get the value like this:

just an fyi

i think it has to be