Is there any way to execute an "IN" clause in a query
with pbeans? I am using mySQL for my database.
What I want is to pull any records where status has one
of several values, so the query I'm looking for is
"select * from forum where status in ('A','B','C','D','E')"
I tried building a String that contained
"('A','B','C','D','E')" and then, using Criteria, I did
criteria.put("status", valuesList, new SimpleOperator("
However, pbeans reformatted the valuesList so that it
caused a mySQL error (it puts tics around the whole
string and escapes the ticks around the values). So,
clearly SimpleOperator wasn't meant to provide "IN"
Any other thoughts?
By the way, I love pbeans!!! I'm a decent OO
programmer, but I *hate* ORM stuff. pbeans has been a
life saver in creating my current project. Thanks for
Log in to post a comment.