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 ...
Search found 1 match
- 20 Oct 2006, 06:24
- Forum: Server Side Extension Development
- Topic: Query Aliases (Select As)
- Replies: 2
- Views: 9538