Ruby on Rails

I had a couple more ideas just after I posted.

Marnen Laibow-Koser wrote:
> Michael Schuerig wrote:
[...]
>> :joins with a symbol does an inner join.
>
> So use an SQL fragment if you need an outer join (which, on reflection,
> I suppose you do).

On further reflection, I don't know why you would need an outer join
unless not every Article has a Version associated. Is that the case?

>
>> When there are several draft
>> versions, which one would I get? Answer: any. I want a specific one: the
>> latest.
>
> You can specify conditions and sort order on fields from joined tables.
> That should do the trick.

Another (possibly zany) idea: group the versions by article_id.

Are you ultimately trying to retrieve the latest version only for each
article? That's what you imply, but a couple of things you wrote made
me thing that you might want to retrieve multiple versions. Which is
it?
[...]

Best,
-- 
Marnen Laibow-Koser
http://www.marnen.org
marnen@marnen.org

Sent from my iPhone
--
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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.