On 9 Mar 2009, at 11:09, engamocap wrote:

>
> Hi all,
>
> I have two tables:
>
> TABLE 1
> A pk - fk (referencesc TABLE 2)
> B pk
> C pk
> D pk
> E
> F
>
> TABLE 2
> A pk
> G
> H
> I
> L
>
> I don't use incremental field (id). I'd like don't use find_by_sql.
> How can I define both models to use correctly find method (with
> include)? With only one column primary key I haven't problems.
> I thought two solutions, but I don't like these very much (especially
> the second):
>
There (at least used to be) a plugin that added composite primary key  
support to rails. I don't remember what it was called (never used it  
myself) but you might be able to track it down.

Fred

> 1) modify TABLE 1 (add field id as primary key and define A,B,C,D as
> unique) and TABLE 2 (column A reference to field id of TABLE 1)
> 2) I use DB web interface only read mode (users cannot write and
> update) and then I can pretend (in model) that TABLE 1 primary key
> were only column A
>
> Can you help me?
>
> Thank you very much
> engamocap
>
> >


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to