Ok, spent many hours looking for appropriate syntax for the formhelper
and controller in 1.2 for this (looked in manuals, API, groups, blogs
etc.). I've decided that I will donate $10 if this issue is resolved!
here's the tables:
urls_users
+-----------------+------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key | Default |
Extra |
+-----------------+------------------+------+-----+---------
+----------------+
| id | int(10) unsigned | NO | PRI | NULL |
auto_increment |
| type_id | int(10) unsigned | NO | MUL | 1
| |
| description | blob | YES | | NULL
| |
| created | datetime | YES | | NULL
| |
| modified | datetime | YES | | NULL
| |
+-----------------+------------------+------+-----+---------
+----------------+
belongsTo:
types
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| type | varchar(20) | YES | | NULL | |
+-------+------------------+------+-----+---------+----------------+
I've baked an 'add' view using urls_users with a form in which I want
a select box populated with Type.type. The default bake does
everything I want except lists the Type.id instead of Type.type. Here
are the controller elements and formhelper stuff:
//controller
$types = $this->UrlsUser->Type-
>find('list',array('fields'=>array('Type.id','Type.type')));
//view
echo $form->input('type_id');
So i modified the controller arguments to include Type.type since the
default find('list') only returned numerical id's. The resulting
query, as displayed at the bottom of the default page view (by the
paginater?),
"SELECT `Type`.`id`, `Type`.`type` FROM `types` AS `Type` WHERE 1 =
1"
does yield the desired results in mysql:
+----+-----------+
| id | type |
+----+-----------+
| 1 | Masculine |
| 2 | Feminine |
+----+-----------+
So I figure I'm missing some syntax either in the view or controller
at or near the above mentioned lines (as far as I can tell). Any help
on how this associated data can be displayed in the selectbox?
Thx,
-B
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
