RE: [flexcoders] [LCDS] Doesn't work with two 'in clause' ?

2009-01-07 Thread Jeff Vroom
rom: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of benjidudu Sent: Wednesday, January 07, 2009 8:17 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] [LCDS] Doesn't work with two 'in clause' ? I am using the SQL assembler in LCDS 2.6. I have a

[flexcoders] [LCDS] Doesn't work with two 'in clause' ?

2009-01-07 Thread benjidudu
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 B