2021-04-07 11:57

sql:Db.use("np3").update(
"DELETE FROM np_media_thirdpart_user m WHERE m.enterprise_id =? AND m.user_id =? AND m.media_id IN (SELECT id FROM np_media_thirdpart WHERE enterprise_id = m.enterprise_id AND module =?)",
eid, uid, module); 我本地运行可以,但是服务器上报错，错误信息如下：com.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mu where mu.enterprise_id=101 and mu.user_id=372140 and mu.media_id in (select i' at line 1

复杂删除Sql语句 Db.update()执行报错。

2018-01-12 13:02

@ALi杰 抱歉，之前忙于工作，没来得及看这个，我用的方法是直接在后台用sql解决了

模板引擎的问题

2017-12-11 11:12

2017-09-26 19:36

@JFinal 好的，谢谢

用vue.js2.0 做上传图片，一直报 Posted content type isn't multipart/form-data

2017-09-26 16:52

@JFinal 也就是说如果要用JFinal的上传模式，就必须要设置请求类型为post且enctype为"multipart/form-data"。

用vue.js2.0 做上传图片，一直报 Posted content type isn't multipart/form-data

2017-09-26 16:42

怎么和Jfinal 融合一下啊

用vue.js2.0 做上传图片，一直报 Posted content type isn't multipart/form-data

2017-09-26 16:34

2017-08-21 12:27

@JFinal 好的，了解，谢谢

JFinal定时任务调度问题

2017-06-06 13:59

我数据表建立了主键，在自动生成model时报“primaryKey required by active record pattern”这个错误

用Generator自动创建base时,疑问.