I am unsuccesfully trying using a "SELECT index_id, vpn_id FROM circuit WHERE index_id in ('123', '234')" sql statement with LCDS' SQL assembler.
In my data-management-config.xml, I configured the sql as "SELECT index_id, vpn_id FROM circuit WHERE index_id in (#list#)". And in Flex, I tried sending 'list' as an Array, a String (with and without quotes) but without success. It always return an empty set but does not return a fault. Does anybody know how I should code this? Thanks, Benjamin.