In my appointments model, I want to order by a column called "when", which is supposed to house the appointment date.
So im my model file appointment.rb I did this... class Appointment < ActiveRecord::Base default_scope :order => 'when' [...] end and I got this error... SQLite3::SQLException: near "when": syntax error: SELECT "appointments".* FROM "appointments" ORDER BY when ----------------------------- So then I used ticks... class Appointment < ActiveRecord::Base default_scope :order => '`when`' [...] end and it worked. I have something similar with my client.rb file, didn't used ticks and never had any problem. class Client < ActiveRecord::Base # Order clients alphabetically default_scope :order => 'name' [...] end Is there a reason for this error? is "when" a reserved keyword? I googled "sqlite3 when" and didn't find anything. Sorry if my question may seem irrelevant, it's just that I want to UNDERSTAND Rails. -- 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.
