Hi Benjamin, I also tried select * from employee where lastname in (123) directly on database console. I got an empty result instead of sql error
William --- In [email protected], "kwbillchan" <[EMAIL PROTECTED]> wrote: > > 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" <benjamin.durin@> > 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. > > >
