尝试搜索电影上映日期比今天大的地方3 F2 }4 G/ F7 H2 d* I* Y) n( L
Movie.where('release > ?', Date.today) & N1 {" ]5 g7 f B6 g! SActiveRecord::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') L% o. q" k% ]1 p' s - V7 w" o; z s 解决方案:4 X$ r+ k* g' t) x. j
% j5 U* [5 C0 X
# O. g, H+ b6 A
2 F. E M/ p. Y9 h& i5 U Rails 3+： 2 f# O0 g8 ~9 M' _Movie.where('release > ?', DateTime.now) 1 x- V6 a5 F0 [; o; D 9 q: k2 q) d9 C2 L$ c% m3 Y8 X) g; q( X预导轨35 A L" `3 |. i# p: L. E# ^1 P4 m
Movie.where(['release > ?', DateTime.now])
技术问答
383 人阅读
|
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')