[flexcoders] SQL query with OR clause

2007-04-13 Thread 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

Re: [flexcoders] SQL query with OR clause

2007-04-13 Thread Greg Morphis
the correct format for a where 'or' clause is where id = '6' or id = '8' or id = '10' you can't do where id = '6' or '8' or '10' not sure what DB you're using but you might want to try where id in ('6','8','10') something like that On 4/13/07, alehrens [EMAIL PROTECTED] wrote: I'm using