IRB and SQL syntax Question

Question

I am trying to write this:

post_view.id = 1

Comment.find(:all, :conditions => "post_parent_id = 'post_view.id'").size

The second statement does not work because that is not an appropriate way to write post_view.id .

Anyoone know the proper syntax?

Answer 1

post_view.id = 1
Comment.find(:all, :conditions => ["post_parent_id = ?", post_view.id]).size