Hi Michel,
Your query is not what i want. Here is my query for sql:
def getUsers(fn: Array[String]) = {
val q = fn.length match {
case 1 =>
val sname = fn(0)
s"select * from users as u where u.sname like ${sname}%"
case 2 =>
val sname = fn(0)
val fname = fn(1)
s"select * from users as u where u.sname like ${sname}% and u.fname like ${fname}%"
case _ =>
val sname = fn(0)
val fname = fn(1)
val mname = fn(2)
s"select * from users as u where u.sname like ${sname}% and u.fname like ${fname}% and u.mname like ${mname}%"
…
here is request to db
}
}