Hi Benjamin,
I tried the in clause statement without any problem. Here are what I
did
<fill>
<name>getSomeEmployees</name>
<sql>
select id as "id", firstname as "firstname",
lastname as "lastname", phonenumber as "phonenumber"
from employee
where id in (#ids#)
and
phonenumber like concat(#areacode#,'%')
</sql>
</fill>
<fill>
<name>getSomeEmployeesWithSameLastName</name>
<sql>
select id as "id", firstname as "firstname",
lastname as "lastname", phonenumber as "phonenumber"
from employee
where lastname in (#lastNames#)
</sql>
</fill>
fill using number array:
var ids: Array = [1,3,5,7,9];
var token: AsyncToken = ds.fill
(people, "getSomeEmployees", {ids:ids,areacode:"617"});
fill using String array:
var lastnames: Array = ["Cattel"];
var token: AsyncToken = ds.fill
(people, "getSomeEmployeesWithSameLastName", {lastNames:lastnames});
William
--- In [email protected], "benjidudu" <[EMAIL PROTECTED]>
wrote:
>
> 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.
>
