Hi William, You are right, it works perfectly as you wrote it. I guess I overthought it while it is simple and easy. Thank you for your help,
Benjamin. P.S.: as a side note, the "in" clause will only work from LCDS 2.6. --- In [email protected], "kwbillchan" <[EMAIL PROTECTED]> wrote: > > 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" <wchan@> 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. > > > > > >
