Hi, I've been stung when deploying a rails app to heroku, and I'm fairly confident the problem is the difference between my local db sqlite3, and the heroku standard free shared db which is postgres(i think).
I have a scope in my model that looks like this scope :not_archived, :conditions => ['application_state != "archived"'] The idea is I want to get back all the records where the application_sate value is not equal to the string "archived". This works fine locally, but in the Heroku logs it throws up the following error : ActionView::Template::Error (PG::Error: ERROR: column "archived" does not exist SELECT COUNT(*) FROM "coach_applications" WHERE "coach_applications"."user_id" = 10 AND (application_state != "archived")): It's looking for a column archived, which is not what I want. Essentially what I want is a proper Rails ORM style scope that returns the rows in a db where the value of column is not equal to something, instead of me having to resort to actual SQL comands in my scope. Any suggestions would be very helpful! I thought this would be easy to find, but the closest I can find is http://stackoverflow.com/questions/5426421/rails-model-find-where-not-equal which still seems pretty messy Thanks -- 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 rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
