Hi all,
I've got a database of events, and (possibly foolishly) I've got column
names such as eventDate, with capital letters. When I want to order the
list of events by their date, I use the line:
@ed_ten_events = AllEvent.where(:city_location => 'Edinburgh',
:ten_event => true).order('eventDate ASC')
This works fine on the local server, but on Heroku it crashes. The logs
reveal that the Heroku Server is being searched with the wrong column
name, one without capitals
ActionView::Template::Error (PGError: ERROR: column "eventdate" does
not exist
LINE 1: ..._events"."city_location" = 'Edinburgh') ORDER BY eventDate
...
Somewhere along the way eventDate is being changed to eventdate, and
this is messing up the search.
I've tested this using columns that don't contain capital letters and it
works fine. So as far as I can tell, my database of events is still
working.
Is there any way of forcing the Heroku 'order' search to keep the
capitals?
Or do I need to change all my columns?
If I have to change columns, is there any way of keeping all the data?
Thanks in advance,
Mike
--
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.
