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 :)

Reply via email to