Re: [SQLObject] join table with meta data

[Ian B. <ia...@co...>]

Barry Christianson wrote:
> Hi,
> 
> I had the following database structure:
> 
> tables charts, items
> and
> chart_items{ chart_id, item_id, item_postion}

Maybe this post would be helpful to you: 
http://xentac.net/~jchu/blog/technology/sqlobject-extra-relatedjoins.html

Generally -- barring extensions like the one described there -- you 
can't have extra fields in a relation.  But you can create a ChartItems 
table and populate it with whatever keys you want, and write your own 
methods for performing the join.

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org