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.

Reply via email to