9 Replies Latest reply on Sep 22, 2010 6:54 PM by -==cfSearching==-

    cfquery fails with conditional query stored in a variable

    Dhrupadh Level 1

      Following code doesnt work. Can anyone explain why?

       

      <cfset myquery="select * from employee where id = '10'">
      <cfquery name="a" datasource="mydsn">
      #myquery#
      </cfquery>