Forum: Ruby on Rails has_many finder_sql #{id} single/double quotes voodoo

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
CSN (Guest)
on 2006-02-13 05:07
(Received via mailing list)
I never would have figured this out in many moons:

  has_many :subscribers, :class_name => "Person",
:finder_sql =>
      'SELECT DISTINCT people.* ' +
      'FROM people p, post_subscriptions ps ' +
      'WHERE ps.post_id = #{id} AND ps.person_id = ' +
      'ORDER BY p.first_name'

Variable interpolation in *single* quotes? Putting it
in double quotes results in a really high number
(541239078 vs. 15 in my case). Is this explained


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
This topic is locked and can not be replied to.