On 10/17/05, modmans2ndcoming <[EMAIL PROTECTED]> wrote:
>
> Does SQLObject allow you to relate different tables and have Primary
> Keys made of multiple columns?
> The object scheme that SQLObject uses does not seem to be conducive to
> a data model that is more complex than a flat table of data.

For relating different tables, look at MultipleJoin and RelatedJoin in
the SQLObject documentation at http://sqlobject.org/SQLObject.html.

As for primary keys made of multiple columns, SQLObject doesn't
support that, and I believe it never will, due to a deliberate design
decision. See the note at the bottom of
http://sqlobject.org/SQLObject.html#many-to-many-relationships for a
brief discussion as to why.

If you want to talk about this in more detail, you're probably going
to get more responses from the SQLObject mailing list. If you're not
signed up for that list yet, you can do so at
http://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss.

Hope this helps.

--
Robin Munn
[EMAIL PROTECTED]
GPG key 0xD6497014

Reply via email to