[flexcoders] SQL query with OR clause

[alehrens]

I'm using HTTPService to do a sql query and it works nicely.  But,
I've not hit a point where I want the query to be a little more complex.  

I want to send this query...

select capacity from capTable where id = ('6' or '8' or '10')

Here's the code I'm currently using....

<mx:HTTPService id="capacityDBQuery"
url="http://localhost:80/QueryDatabase/"; method="GET"
fault="Alert.show(event.fault.message, 'Error')"
result="handleDBQuery(event)">          
  <mx:request>
    <select>
        capacity
    </select>
    <from>
        capTable
    </from>     
    <where>
        id
    </where>
    <equals>
        {ids}
    </equals>   
  </mx:request>
</mx:HTTPService>

ids is a bindable variable that is set to ('6' or '8' or '10')

When setting ids to just one value, like ('6'), the query works fine.
 But, when using the multiple IDs, my NewDataSet return value is NULL.  

Please help?