FormHelper will do the right thing if you set a var for the view
holding the Organization names. This is something I've tried--and
failed-- to figure out from the source.
controller:
public function whatever()
{
if (!empty($this->data))
{
// ...
}
$this->set(
'organizations',
$this->User->Organization->find('list')
);
}
view:
echo $form->input('User.organization_id', array(whatever attributes
you need set));
Somehow, it just works.
On Mon, Aug 17, 2009 at 10:18 PM, Magua<[email protected]> wrote:
>
> Thanks. Working now except on my forms the drop-down lists display the
> id # instead of the field.
> for example the drop down for Organization displays id 3 and id 4
> instead of the Organization Name.
> Here is all my code:
>
> organization model
> <?
> class organization extends AppModel {
> var $name = 'Organization';
> var $hasMany = array('User');
> }
> ?>
>
> type model
> <?
> class type extends AppModel {
> var $name = 'Type';
> var $hasMany = array('User');
> }
> ?>
>
> user model
> <?
> class user extends AppModel{
> var $name = 'User';
> var $belongsTo = array('Organization','Type');
> }
> ?>
>
> organizations_controller
> <?
> class OrganizationsController extends AppController {
> var $name = 'Organization';
> var $scaffold;
> }
> ?>
>
> types_controller
> <?
> class typesController extends AppController {
> var $name = 'Type';
> var $scaffold;
> }
> ?>
>
> users_controller
> <?
> class UsersController extends AppController {
> var $name = 'User';
> var $scaffold;
> }
> ?>
>
>
> On Aug 17, 9:22 pm, brian <[email protected]> wrote:
>> Heh, normally, having the link wouldn't do much good; you'd need to
>> provide your find() code. But:
>>
>> SELECT `User`.`id`, `User`.`type_id`, `User`.`organizations_id`, ...
>>
>> It looks to me like you created a column named 'organizations_id'
>> rather than 'organization_id'. The latter is what you want. Cake
>> picked it up when it issued 'DESCRIBE users' in order to get the table
>> schema. So, your code is probably good and you just need to modify the
>> column name.
>>
>>
>>
>> On Mon, Aug 17, 2009 at 4:08 PM, Magua<[email protected]> wrote:
>>
>> > URL
>> >http://beta.openaccessinc.com/users
>>
>> > On Aug 17, 3:46 pm, Magua <[email protected]> wrote:
>> >> I am now generating the following error when i load users
>> >> Warning (512): SQL Error: 1054: Unknown column 'User.organization_id'
>> >> in 'on clause' [CORE/cake/libs/model/datasources/dbo_source.php, line
>> >> 524]
>>
>> >> Here are my models
>>
>> >> organizaton.php
>> >> <?
>> >> class organization extends AppModel {
>> >> var $name = 'organization';
>> >> var $hasMany = array('User');
>> >> }
>> >> ?>
>>
>> >> type.php
>> >> <?
>> >> class type extends AppModel {
>> >> var $name = 'Type';
>> >> var $hasMany = array('User');}
>>
>> >> ?>
>>
>> >> user.php
>> >> <?
>> >> class user extends AppModel {
>> >> var $name = 'User';
>> >> var $belongsTo = array('Type','Organization');
>>
>> >> }
>>
>> >> ?>
>>
>> >> On Aug 17, 3:18 pm, brian <[email protected]> wrote:
>>
>> >> > Just add the model to $belongsTo array.
>>
>> >> > User:
>> >> > var $belongsTo = array('Type', 'Organization');
>>
>> >> > Organization:
>> >> > var $hasMany = array('User');
>>
>> >> > On Mon, Aug 17, 2009 at 3:04 PM, Magua<[email protected]> wrote:
>>
>> >> > > Thanks I have it working now.
>> >> > > But i now need a another $belongs to declaration in my "user.php"
>> >> > > model.
>> >> > > How does cake handle this.
>>
>> >> > > For example i have now added an "organizations" table with the
>> >> > > following fields
>> >> > > id, name
>>
>> >> > > and i have added the following field to the "users" table.
>> >> > > organization_id
>>
>> >> > > Each user can only Belong To one organization.
>>
>> >> > > How is this done
>>
>> >> > > On Aug 17, 1:30 pm, brian <[email protected]> wrote:
>> >> > >> You forgot the "array" part:
>>
>> >> > >> var $hasOne = array('Type');
>>
>> >> > >> BUT you probably want:
>>
>> >> > >> var $belongsTo = array('Type');
>>
>> >> > >> Type:
>> >> > >> var $hasMany = array('User');
>>
>> >> > >> If you used Group instead of Type it would make more sense.
>>
>> >> > >> On Mon, Aug 17, 2009 at 12:52 PM, Magua<[email protected]> wrote:
>>
>> >> > >> > Please note I am a very GREEN newby to MVC programing.
>>
>> >> > >> > I have 2 tables.
>> >> > >> > 1.> users
>> >> > >> > Fields: id, user, type_id
>> >> > >> > 2.> types
>> >> > >> > Fields: id, type
>>
>> >> > >> > Each user can have only 1 "type" and each "type" can have many
>> >> > >> > "users".
>> >> > >> > I have created the following models.
>>
>> >> > >> > user.php
>> >> > >> > <?
>> >> > >> > class User extends AppModel {
>> >> > >> > var $name = 'User';
>> >> > >> > var $hasOne = 'Type';
>> >> > >> > }
>> >> > >> > ?>
>> >> > >> > The above model generates this error.
>> >> > >> > Parse error: syntax error, unexpected '(' in
>> >> > >> > /var/www/beta/htdocs/app/
>> >> > >> > models/kind.php on line 4
>>
>> >> > >> > type.php
>> >> > >> > <?
>> >> > >> > class type extends AppModel {
>> >> > >> > var $name = 'type';
>> >> > >> > var $hasMany = ('user');
>> >> > >> > }
>> >> > >> > ?>
>> >> > >> > The type error generates this error.
>> >> > >> > Parse error: syntax error, unexpected '(' in
>> >> > >> > /var/www/beta/htdocs/app/
>> >> > >> > models/type.php on line 4
>>
>> >> > >> > What am i doing wrong? Is this not a hasOne Relationship.
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
