<CFLOOP QUERY="query_name" STARTROW="row_num" ENDROW="row_num">
A loop over a query repeats for every record in the query record set. The CFLOOP results are just like a CFOUTPUT. During each iteration of the loop, the columns of the current row will be available for output. CFLOOP allows you to loop over tags that can not be used inside CFOUTPUT.
Required. Specifies the query that will control the loop.
Optional. Specifies the first row of the query that will be included in the loop.
Optional. Specifies the last row of the query that will be included in the loop.