cfoutput - get output of a query (defined start rows)
cfoutputStartRow.cfm
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>cfoutput tag example: how to get output of a query (defined start rows) in coldfusion</title>
</head>
<body>
<h2 style="color:Crimson">cfoutput Tag Example: Query [startrow]</h2>
<cfquery name="qEmployees" datasource="cfdocexamples">
SELECT Emp_ID, LastName, FirstName, Phone FROM EMPLOYEES
</cfquery>
<table cellpadding="0" cellspacing="0" bordercolor="DodgerBlue" border="1">
<tr bgcolor="DodgerBlue" style="color:White">
<td><b>Emp ID</b></td>
<td><b>Last Name</b></td>
<td><b>First Name</b></td>
<td><b>Phone</b></td>
</tr>
<cfoutput query="qEmployees" maxrows="5" startrow="5">
<tr>
<td>#Emp_ID#</td>
<td>#LastName#</td>
<td>#FirstName#</td>
<td>#Phone#</td>
</tr>
</cfoutput>
</table>
</body>
</html>
