2 Replies Latest reply on May 10, 2006 3:20 PM by kellyhondalovesmusic

    grids,  cells, for my query output

    briankind Level 1
      hi i have this query that will display result.
      i need to put it in a record like results with ( being in a cell) in html
      what do i have to add here. to make this happen?

      columns being in a cell and rows and records within that columns too??


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

      <html>
      <head>
      <title>CF TUTORIALS</title>
      <link rel="stylesheet" href="styles.css">
      </head>

      <body>

      <h1>All CO Listings</h1>

      <table>
      <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="Myqueryname">
      <tr>
      <td>#CompanyID#</td>
      <td>#CompanyName#</td>
      <td>#Address#</td>
      <td>#City#</td>
      <td>#State#</td>
      <td>#ZipCode#</td>
      <td>
      <a href=" ALL Emps.cfm?CompanyID=#CompanyID#">ALL Emps</a>
      <a href=" AddCO Form.cfm">AddCO</a>
      <a href=" Editco.cfm?CompanyID=#CompanyID#">Editco</a>
      <a href="CoDeleteForm.cfm?CompanyID=#CompanyID#">Delete</a>
      </td>
      </tr>
      </cfoutput>
      </table>

      </body>
      </html>