You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
long[] idArr = { 1, 2, 3 };
// 以下这句是OK的
query(Cnd.where("ID", "IN", idArr), null);
// 以下的代码报错
Sql sql = Sqls.create("SELECT * FROM PETS WHERE ID IN @idarr");
sql.params().set("idArr", idArr);
dao().execute(sql);
下面是报错信息
DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT * FROM PETS WHERE ID IN '[J@a0560e'
Syntax error in SQL statement "SELECT * FROM PETS WHERE ID IN ?"; expected "("; SQL statement:
Cnd的where()方法实现的很好啊,为什么自定义SQL的参数占位符设值不支持呢?
The text was updated successfully, but these errors were encountered:
上代码:
long[] idArr = { 1, 2, 3 };
// 以下这句是OK的
query(Cnd.where("ID", "IN", idArr), null);
// 以下的代码报错
Sql sql = Sqls.create("SELECT * FROM PETS WHERE ID IN @idarr");
sql.params().set("idArr", idArr);
dao().execute(sql);
下面是报错信息
DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT * FROM PETS WHERE ID IN '[J@a0560e'
Syntax error in SQL statement "SELECT * FROM PETS WHERE ID IN ?"; expected "("; SQL statement:
Cnd的where()方法实现的很好啊,为什么自定义SQL的参数占位符设值不支持呢?
The text was updated successfully, but these errors were encountered: