<cffunction name="getmemberinfo" access="remote"
returnType="struct">
<cfargument name="cid" type="numeric" required="true">
<cfset var memcat="">
<cfset var c = "">
<cfset var f = structNew()>
<cftry>
<cfquery name="memcat" datasource="#applicationdsn#">
SELECT members.memberrecordid, CategorData.CatdataId,
Category.CatId, Category.Category, Contacts.cid
FROM CategorData FULL OUTER JOIN
Category ON CategorData.CatId = Category.CatId FULL OUTER
JOIN
members ON CategorData.memberrecordid =
members.memberrecordid FULL OUTER JOIN
Contacts ON members.cid = Contacts.cid
WHERE Category.CatId= <cfqueryparam
cfsqltype="cf_sql_integer" value="#arguments.cid#">
</cfquery>
<!--- --->
<cfloop list="#memcat.columnlist#" index="c">
<cfset f = data[1]>
</cfloop>
<cfcatch type="any">
<cfset returnStruct.success = false />
<cfset returnStruct.message = cfcatch.message />
</cfcatch>
</cftry>
<cfreturn f>
</cffunction>