Hello guys i have the following tables; biodata[biodata_id, f_name, l_name,
o_name, team], collections[collections_id, ID_biodata, amountPaid,
amountExpected, balance, quater, datePaid].
There are 5 teams each with 4 members. i would like to generate a list in flex
to show how much each member has paid and to display the data by showing only 5
teams and members in each team under the team name.
i have the following query but i get errors. could someone please help me.
<cffunction name="getTeams" output="false" access="remote" returntype="query">
<cfset var qteams = "" />
<cfset var result= "">
<cfquery datasource="bond100" name="qteams">
SELECT biodata_id, f_name + ' ' + l_name AS fullname, o_name, team,
collections_id, ID_biodata, amountPaid, amountExpected, balance, datePaid
FROM biodata, collections
WHERE biodata_id = ID_biodata
</cfquery>
<cfquery dbtype="query" name="results">
SELECT team, fullname, amountPaid, amountExpected, balance, datePaid
FROM qteams
GROUP BY team
</cfquery>
<cfreturn results/>
</cffunction>
the error i get is "The column qteams.fullname is invalid in the SELECT list
clause because it is not contained in either an aggregate function or the GROUP
BY clause."
