1 Reply Latest reply on Apr 28, 2015 9:19 PM by philmodjunk

    executesql -> Is the OR operator Broken or is it just me?

    ZackSlates

      Title

      executesql -> Is the OR operator Broken or is it just me?

      Post

      I set a variable $query

      I set another variable $sqloutput which is this: ExecuteSQL ( $query; "";"" )

      When I set $query to:

      1) Select Display_Name,PhysicianSer From Physician Where Type = 'Refer To Only'

         - It Works

      2) Select Display_Name,PhysicianSer From Physician Where Type = 'Both'

         - It Works

      3) Select Display_Name,PhysicianSer From Physician Where Type = 'Both' OR Type = 'Refer To Only'

         - It Only Gives be the both results

      FYI I've tried

      1)encapsulating it in (), no luck

      2)Using In ('Both',Refer To Only') No luck

       

      Can someone explain why?