Rails: SQL Error

Question

I'm getting a SQL error with this:

Model:

class Comment < ActiveRecord::Base
    belongs_to :user
    belongs_to :entry

    attr_accessible :body

    validates :user_id, :presence => true
    validates :entry_id, :presence => true
    validates :body, :presence => true, :length => {:minimum => 10, :maximum => 5000}  #spam/stupid protection

    default_scope :order => 'comments.created at sec'
end

Controller

  def show
        @entry = Entry.find(params[:id])
            @comments = @entry.comments.all
  ...  
      respond_to do |format|
      format.html # show.html.erb
      format.xml  { render :xml => @entry }
    end
  end

The view is a simple:

<% if @entry.state > 2 %>
    <section id="comments"> 
        <% @comments.each do |comment| %>
...loop some stuff...

Tess Rosania · Accepted Answer · 2011-06-30 06:12:18Z

2

It looks like you want :order => 'comments.created_at desc', not sec.

answered Jun 30, 2011 at 6:12

Tess Rosania

10.1k2 gold badges22 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kevin Brown Over a year ago

Yup. You got it. My bad here...I'm new to programming rails!

Tess Rosania Over a year ago

It's a learning process. :) In general, :order and :conditions, when given string arguments, interpret them as raw SQL, so keep that syntax in mind. If you need to do interpolation, you can use an array construct like so: ["foo = ?", bar] and bar will be sanitized.

Tudor Constantin · Accepted Answer · 2011-06-30 06:11:09Z

0

And what exactly is the error you are receiving?

I think your error is from here:

default_scope :order => 'comments.created at sec'

Because comments.created at sec you can't have that field in DB

answered Jun 30, 2011 at 6:11

Tudor Constantin

26.9k7 gold badges54 silver badges73 bronze badges

Collectives™ on Stack Overflow

Rails: SQL Error

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related