Search found 1 match

by harkonen
20 Oct 2006, 06:24
Forum: Server Side Extension Development
Topic: Query Aliases (Select As)
Replies: 2
Views: 9538

Query Aliases (Select As)

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 ...