html report with a numbering from 1 record to last record that comes out.

Report · Jul 06, 2006

hi can anyone help me on how to put a numbering on ethe rows/records. for example
where colnumbering is a extra cel that list a numbering for the records.

if there are 350 records on the html report then it will contain 1 to 350 in that column.
is this possible, if so where do i put it in myu code??

thanks again

colnumbering column1 column2
1 nancy woods
2
3
4
5
6

thanks in advance

<cfquery name="GetCompanies"
datasource="#Request.MainDSN#">
SELECT
CompanyID,
CompanyName,
Address,
City,
State,
ZipCode,
Comments
FROM
Company
ORDER BY
CompanyName ASC
</cfquery>

<html>
<head>
<title>ColdFusion MX Bible</title>
<link rel="stylesheet" href="styles.css">
</head>

<body>

<h1>Company List</h1>

<TABLE width=100% align="left" border="4" rules="all">
<tr>

<td><b>ID</b></td>
<td><b>Name</b></td>
<td><b>Address</b></td>
<td><b>City</b></td>
<td><b>State</b></td>
<td><b>ZIP Code</b></td>
<td> </td>
</tr>
<cfoutput query="GetCompanies">
<tr>

<td>#CompanyID#</td>
<td>#CompanyName#</td>
<td>#Address#</td>
<td>#City#</td>
<td>#State#</td>
<td>#ZipCode#</td>
<td>
<a href="EmployeeList.cfm?CompanyID=#CompanyID#">Employees</a>
<a href="CompanyAddForm.cfm">Add</a>
<a href="CompanyEditForm.cfm?CompanyID=#CompanyID#">Edit</a>
<a href="CompanyDeleteForm.cfm?CompanyID=#CompanyID#">Delete</a>
</td>
</tr>
</cfoutput>
</TABLE>

</body>
</html>

Report · Jul 07, 2006

Use the query variable CurrentRow. It will do what you describe.

<td>#CurrentRow#</td>

Report · Jul 07, 2006

thanks,

where do i put it in the code.

Report · Jul 07, 2006

right before
<td>#CompanyID#</td>

Adobe Community

html report with a numbering from 1 record to last record that comes out.

1 Correct answer