0 Replies Latest reply on Jul 20, 2006 9:11 AM by kellyhondalovesmusic

    input in text box and outputs the query results

    kellyhondalovesmusic
      Hello
      i have this query and i wish to create a first page or a index with a
      text box that a user can input a company ID then it out puts based on that id.

      how do i do this?


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