Re: One-way relationship

Your model relationship should actually be:

Item belongsTo Unit
Unit hasMany Items (optional)

In the Cookbook subsection ""3.7.6.3 belongsTo" (http://
book.cakephp.org/view/1039/Associations-Linking-Models-
Together#belongsTo-1042, part of "3.7.6 Associations: Linking Models
Together"), there is a note:

"If a model(table) contains a foreign key, it belongsTo the other
model(table)."

On May 29, 3:53 pm, Mondo <mo...@nodegarden.net> wrote:
> I have Items and Units, and want each Item to have one Unit, but that
> unit can be used by many.
>
> Items Table
> id - int
> name - varchar
> description varchar
> unit_id - int
>
> Units Table
> id - int
> name - varchar
> description - varchar
>
> Items Model
> var $hasOne = array( 'Units' => array( 'className' => 'Unit' ) );
>
> Units Model
> Nothing, but previously I tried:  var $belongsTo = array( 'Items' =>
> array( 'className' => 'Item' ) );
>
> When I'm in the scaffolding (List Items) I get:
> Warning (512): SQL Error: 1054: Unknown column 'Units.item_id' in 'on
> clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
>
> And in the Edit Item screen, the Units drop-down is empty. Any idea
> what I'm doing wrong? Essentially the Units table are just to populate
> a drop-down in the Item entry form, but I'd like it to auto-populate
> in scaffold.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php