I'm working on creating a model that allows redirect to another
instance of the same type (Page). For obvious reasons, I don't want
it to be able to redirect to itself. How can I get the model to
properly filter this relationship? I'm currently getting the error:
Mysql2::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '' at line 1: SELECT `pages`.* FROM `pages` WHERE (id !=
#{self.id})
>From what I've read, it should be replacing #{self.id} with the
current instance.
class Page < ActiveRecord::Base
has_ancestry
belongs_to :footer,
:foreign_key => 'footer_id',
:class_name => 'ReusableText'
belongs_to :redirect_to_page,
:foreign_key => 'redirect_to_page_id',
:class_name => 'Page',
:conditions => 'id != #{self.id}'
...
--
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.
