Weird issue:
I have a query that works fine--produces expected results:
SELECT COUNT(tagsLU.tagid) as 'tagcount', tag.tagname as 'tagname' FROM TagsLU
Inner Join tag on tag.tagid=tagslu.tagid Group By tag.tagname Order By tagcount
DESC
....which produces an array like this:
5 school
4 volunteer
2 casual
2 family
1 house
1 work
HOWEVER, when I retrieve through AS3 and run a trace, I get this:
tag: casual; tagcount: 0
tag: family; tagcount: 0
tag: housework; tagcount: 0
tag: school; tagcount: 0
tag: volunteer; tagcount: 0
tag: work; tagcount: 0
Here's the trace code:
...
var result:SQLResult = tagsStmt.getResult();
var numResults:int=result.data.length
for (var i:int = 0; i < numResults; i++)
{
var row:Object = result.data[i];
var output:String =" tag: " + row.tagname;
output += "; tagcount: " + row.tagcount;
trace(output);
}
Any thoughts? I'm sooo close to finishing :)