AnsweredAssumed Answered

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

Question asked by ZackSlates on Apr 28, 2015
Latest reply on Apr 28, 2015 by philmodjunk

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?

Outcomes