<cfquery name="myqueryname" datasource="mydatabase">
    select * from table
</cfquery>

<cfoutput query = "myqueryname">
    #field1# #field2# <br/>
</cfoutput>