5 Replies Latest reply on Oct 18, 2017 6:27 AM by WolfShade

    ColdFusion ORM

    Sateesh Level 1

      I have query which should filter the where clause condition depends on the URL parameter to the page?

       

       

      With CFQuery:

       

      <cfquery name="GetUser" datasource="Sample">

          Select *from Users

          where <cfif url.type EQ 1>userid=123<cfelse>userid=456</cfif>

      </cfquery>

       

      the same query i am tryinng to write with ORMExecuteQuery, i am failing to write it.

       

      Please help me on this.

       

      Thanks in advance