Sample Report

<cfquery name="get_data" datasource="data_source">
select * from maillist where active_flag=1
</cfquery>

<table border=1>
<tr><th>ID<th>last_name<th>first_name<th>email_address
<cfoutput query="get_data">
<tr><td>#id#<td>#last_name#<td>#first_name#<td>#email_address#
</cfoutput>
</table>