3 Replies Latest reply on Jul 7, 2006 10:18 AM by Dan Bracuk

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

    kellyhondalovesmusic
      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>