12 Replies Latest reply on Jun 12, 2008 9:14 AM by Dan Bracuk

    Query Questions

    brianism
      Hello all,
      I am trying to pull out information from the database based on what a link is passing. But I am pulling out information I don't need.

      Here are my links:

      cad1.cfm?headmodel=14

      cad1.cfm?headmodel=14V

      And the Query:

      <cfquery name="getforce" datasource="mydb">
      SELECT * FROM presses WHERE model_head LIKE '#headmodel#%'
      </cfquery>

      Now my problem is that I need only the results with a V in it to come up when using that link and vice versa. But they come up when using the link without the V as well.