 
 <cfset summary=querynew("u,p,s,c")>
 <cfoutput>
+
+		<cfquery name="CTCOLL_CONTACT_ROLE" datasource="uam_god">
+			select CONTACT_ROLE from CTCOLL_CONTACT_ROLE order by guid_prefix
+		</cfquery>
+
 	<cfquery name="colns" datasource="uam_god">
 		select * from collection order by guid_prefix
 	</cfquery>

				collection_contacts.collection_id=#collection_id# and
				collection_contacts.contact_agent_id=agent.agent_id
		</cfquery>

		<cfdump var=#contacts#>


	</cfloop>
<!----


		<cfquery name="users" datasource="uam_god">
			select
				grantee,
				preferred_agent_name
			from
				dba_role_privs,
				agent_name,
				dba_users,
				agent
			where
				upper(dba_role_privs.granted_role)= upper(replace('#guid_prefix#',':','_')) and
				dba_role_privs.grantee=upper(agent_name.agent_name) and
				agent_name.agent_name_type='login' and
				agent_name.agent_id=agent.agent_id and
				dba_role_privs.grantee=dba_users.username and
				dba_users.account_status='OPEN'
		</cfquery>
		<p>
			Active Collection Users
			<table border>
				<tr>
					<td>PreferredName</td>
					<td>Username</td>
				</tr>
				<cfloop query="users">
					<tr>
						<td>#preferred_agent_name#</td>
						<td>#grantee#</td>
					</tr>
				</cfloop>
			</table>
		</p>

		<cfquery name="contacts"  datasource="uam_god">
			select
