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>



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


      Please help me on this.


      Thanks in advance