尝试搜索电影上映日期比今天大的地方* X R1 w* a0 d6 S: e- h- t) L0 a
Movie.where('release > ?', Date.today)( d4 A9 v+ _+ B/ q, J8 C6 T. h
ActiveRecord::StatementInvalid: Mysql:arseError: 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 'release > '2011-09-25')' at line 1: SELECT `movies`.* FROM `movies` WHERE (release > '2011-09-25')6 N4 t0 V" L% l6 a
D; W- F$ P8 }+ s! f6 P: f* c 解决方案: r- ? a: {8 s! k; F! |" i. T . a- B- S0 D, B9 O( H1 P0 Y7 A: {/ y$ R @* @
9 c) B& Y n/ M8 V4 z Rails 3+：7 x& W, J, U3 t, L3 s
Movie.where('release > ?', DateTime.now) , q/ q L8 P) G7 ?4 [9 w 2 ?" h3 s- `# G预导轨3+ Z' e/ I: t, \0 h P- A: u# m
Movie.where(['release > ?', DateTime.now])
技术问答
337 人阅读
|
0 人回复
|
2023-09-14
arseError: 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 'release > '2011-09-25')' at line 1: SELECT `movies`.* FROM `movies` WHERE (release > '2011-09-25')6 N4 t0 V" L% l6 a