 			select account_status FROM dba_users where username='#users.username#'
 		</cfquery>
 
-		<cfset queryaddrow(summary,
-			{u=users.username,
-			p=users.preferred_agent_name,
-			s=acts.account_status}
-		)>
+
 
 
 

	.hasNoContact{color:red;}
</style>

<cfset summary=querynew("u,p,s")>
<cfoutput>
	<cfsavecontent variable="details">


	</cfsavecontent>
	Summary

	<cfquery name="os" dbtype="query">
		select * from summary order by c,s,u
	</cfquery>

	<table border>
		<tr>
			<th>Username</th>
			<th>Preferred Name</th>
			<th>Account Status</th>
			<th>Problem</th>
		</tr>
		<cfloop query="os">
			<tr>
				<td>#u#</td>
				<td>#p#</td>
				<td>#s#</td>
				<td>#c#</td>
			</tr>
		</cfloop>
	</table>
