1 Thank you!it's help me. I guess that this is the problem.
Hassan Schroeder wrote in post #1011501: > On Mon, Jul 18, 2011 at 3:04 PM, Aegorov Egorov <[email protected]> > wrote: > >> SQLite3::SQLException: near "to": syntax error: SELECT COUNT(*) FROM >> "likes" WHERE ("likes".to = 1) >> in sqlite console sql query working with this syntax >> SELECT COUNT(*) FROM "likes" WHERE ("likes"."to" = 1) > > Apparently the SQLite3 adapter isn't quoting that field name, and > unfortunately for you, "TO" is a SQL reserved word. > > The best solution would be to change that. :-) > > HTH, > -- > Hassan Schroeder ------------------------ [email protected] > http://about.me/hassanschroeder > twitter: @hassan -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
