How to use CFquery result attribute in ColdFusion

cfquery - result attribute

cfqueryResult.cfm


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>cfquery tag example: how to use result attribute</title>
</head>

<body>
<h2 style="color:hotpink">cfquery example: using result</h2>

<cfquery name="qMembers" datasource="cfcodeexplorer" result="members">
 SELECT MemberID, lastname, FirstName, Email FROM MEMBERS
</cfquery>
<cfdump var="#Members#" label="Result">
<cfdump var="#qMembers#" label="Query">
</body>
</html>





More ColdFusion examples