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 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?
>
>
>
> --
> Flexcoders Mailing List
> FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
> Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
> Yahoo! Groups Links
>
>
>
>
