This discussion is archived
3 Replies Latest reply: Nov 21, 2013 1:05 PM by cdelahun RSS

DataReadQuery List parameter for IN clause

amehta5 Newbie
Currently Being Moderated

How do you send a List parameter for IN clause to a DataReadQuery?

I am trying the below code but cannot get the list param working.

 

  String sql = “select * from myTable where col1 in (#listParam)”

  final DataReadQuery query = new DataReadQuery(sql);

  resultVector = (Vector<DatabaseRecord>)session.executeQuery(query, args);

 

Thanks for the help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points