2 Replies Latest reply on Jul 2, 2006 9:09 AM by flooker

    SQL Encapsulation In variable

    flooker
      I think i am missing some thing . when i am doing some thing like this its working

      <cfset QueryA = "Select * from Test">
      <cfquery name="ABC" datasource="ABC">
      #QueryA#
      </cfquery>

      But how to Add where in IT . ??

      <cfset QueryA = "Select * from Test where country = 'US' ">
      <cfquery name="ABC" datasource="ABC">
      #QueryA#
      </cfquery>

      i am just trying to make a Dynamic Query . any other ideas are welcomed