cfmail help

I have the following query that will give me email address and I put into cfmail. I am passing a value (in this case 7) into the form.site varaible. For my test sample, there are 8 records but for some reason, I am only getting one name. I have two queries, one dyanamically and one hardcoded, and the hardcode one seems to give me everyone but the other one only gives me one name. Both queries are/sould be the same.

I cannot see what the problem is, can somebody please help ?


<cfif isDefined("form.site")>
<cfoutput>form.site is #form.site#<br></cfoutput>

dynamic starts here

<cfquery name="qryGet_roles" datasource="recDisc">
select
user_employee_number,
user_name,
user_email,
user_status,
role_id
from tblUnReceivables_User_Directory
where role_id in ('#form.site#')
and (user_status = 'Active')
order by role_id, user_name
</cfquery>


<cfoutput query="qryGet_Roles">#user_email#<br></cfoutput>


hardcoded starts here

<cfquery name="qryGet_roles_1" datasource="recDisc">
select
user_employee_number,
user_name,
user_email,
user_status,
role_id
from tblUnReceivables_User_Directory
where role_id in ('7')
and (user_status = 'Active')
order by role_id, user_name
</cfquery>

<cfoutput query="qryGet_Roles_1">#user_email#<br><cfabort></cfoutput>

<cfmail to="#qryGet_Roles.user_email#"
cc="#form.additional_email#"
from="UnReceivables Team"
subject="URDN #form.urdn_number#"
query="qryGet_Roles"
type="html">