[flexcoders] Re: Problem losing values from query results to RESULT.DATA
fixed--issue was COUNT. Select COUNT(*) fixed the issue... --- In flexcoders@yahoogroups.com, Tim Romano tim_rom...@... wrote: What happens if you don't put any quotes around the column aliases? Tim On 1/19/2010 4:55 PM, charliecrystle wrote: 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
[flexcoders] Re: Problem losing values from query results to RESULT.DATA
thanks--same result. --- In flexcoders@yahoogroups.com, Tim Romano tim_rom...@... wrote: What happens if you don't put any quotes around the column aliases? Tim On 1/19/2010 4:55 PM, charliecrystle wrote: 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