Unfortunately the SQL assembler appears to be hardcoded to deal with support for a single "in clause". It has to parse the SQL statement to support the in clause so it can convert the array parameter to the right JDBC calls. I'll make sure a bug gets filed on this.
Jeff From: [email protected] [mailto:[email protected]] On Behalf Of benjidudu Sent: Wednesday, January 07, 2009 8:17 AM To: [email protected] Subject: [flexcoders] [LCDS] Doesn't work with two 'in clause' ? I am using the SQL assembler in LCDS 2.6. I have a fill with two 'in clause' that causes a SQL error: index out of range. If my fill is: SELECT * FROM statDetails WHERE destination_ip in (#destinations#) it works If my fill is: SELECT * FROM statDetails WHERE source_ip in (#sources#) it works But if my fill is: SELECT * FROM statDetails WHERE destination_ip in (#destinations#) AND source_ip in (#sources#) it makes a fault and the sql error is: index 13 out of range (note that my arrays each have 11 elements) I tried the query directly in the sql server and it works so I think it is a problem with LCDS. Does anybody know what's going on? Benjamin.
<<inline: image001.jpg>>
<<inline: image002.jpg>>
