The second method will still work with 1.2
On Dec 3, 3:38 pm, salimk786 <[EMAIL PROTECTED]> wrote:
> It says Class 'Set' not found....
> I'm on Cake 1.4 not the 2.
>
> Thanks.
>
> On Dec 3, 4:30 am, grigri <[EMAIL PROTECTED]> wrote:
>
> > // Method one : use Set::extract()
> > $data = $this->Attribute->findAll(...);
>
> > $ids = Set::extract($data, '{n}.Attribute.id});
> > $status_arr = array_combine($ids, Set::extract($data,
> > '{n}.Attribute.status'));
> > $value_arr = array_combine($ids, Set::extract($data,
> > '{n}.Attribute.value'));
> > ...
>
> > // Method two: do it manually
> > $fieldsIWant = array('status', 'value', ...);
> > $extractedData = array();
> > $data = $this->Attribute->findAll(...);
> > foreach ($data as $row) {
> > $id = $row['Attribute']['id'];
> > foreach ($fieldsIWant as $field) {
> > $extractedData[$field][$id] = $row['Attribute'][$field];
> > }}
>
> > // Now call $this->set('my_status_arr', $extractedData['status']), ...
>
> > On Dec 3, 5:42 am, salimk786 <[EMAIL PROTECTED]> wrote:
>
> > > I have this table:
>
> > > CREATE TABLE `attributes` (
> > > `id` int(10) unsigned NOT NULL auto_increment,
> > > `controller` varchar(25) default NULL,
> > > `category` varchar(25) NOT NULL,
> > > `item` varchar(25) NOT NULL,
> > > `value` varchar(50) NOT NULL,
> > > `created` datetime default NULL,
> > > `modified` datetime default NULL,
> > > PRIMARY KEY (`id`)
> > > )
>
> > > //sample data
> > > INSERT INTO `attributes` VALUES(1, 'Profiles', 'Basics', 'Lookingto',
> > > 'Friendship', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> > > INSERT INTO `attributes` VALUES(2, 'Profiles', 'Basics', 'Lookingto',
> > > 'A Relationship', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> > > INSERT INTO `attributes` VALUES(6, 'Profiles', 'Basics',
> > > 'Relationshipstatus', 'Single', '0000-00-00 00:00:00', '0000-00-00
> > > 00:00:00');
> > > INSERT INTO `attributes` VALUES(7, 'Profiles', 'Basics',
> > > 'Relationshipstatus', 'Committed', '0000-00-00 00:00:00', '0000-00-00
> > > 00:00:00');
> > > INSERT INTO `attributes` VALUES(11, 'Profiles', 'Basics', 'Bodytype',
> > > 'Slim', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> > > INSERT INTO `attributes` VALUES(12, 'Profiles', 'Basics', 'Bodytype',
> > > 'Slender', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> > > INSERT INTO `attributes` VALUES(72, 'Profiles', 'Lifestyle',
> > > 'Drinker', 'Yes', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> > > INSERT INTO `attributes` VALUES(73, 'Profiles', 'Lifestyle',
> > > 'Drinker', 'No', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> > > INSERT INTO `attributes` VALUES(74, 'Profiles', 'Lifestyle',
> > > 'Drinker', 'I will tell you later', '0000-00-00 00:00:00', '0000-00-00
> > > 00:00:00');
>
> > > --> I do not like doing this:
> > > $this->set('arr_attribute_idlookingTo',$this->Attribute->generateList(array-('controller'
> > > => $this->name, 'category' =>
>
> > > 'Basics', 'item' => 'Lookingto'), 'id ASC', 0, '{n}.Attribute.id',
> > > '{n}.Attribute.value'));
> > > $this->set('arr_attribute_idrelationshipstatus',$this->Attribute->generateL-ist(array('controller'
> > > => $this->name, 'category' =>
>
> > > 'Basics', 'item' => 'Relationshipstatus'), 'id ASC', 0,
> > > '{n}.Attribute.id', '{n}.Attribute.value'));
> > > $this->set('arr_attribute_idlifestyle',$this->Attribute->generateList(array-('controller'
> > > => $this->name, 'category' =>
>
> > > 'Basics', 'item' => 'Lifestyle'), 'id ASC', 0, '{n}.Attribute.id',
> > > '{n}.Attribute.value'));
>
> > > I dont' like doing that because i am querying the database so many
> > > times.
> > > I'd rather do a findAll $condtions = array('controller' => $this->name)
>
> > > and then somehow call the getFieldValue to do whatever it does
> > > that takes keys and values out of the data from the findAll...
>
> > > Can someone tell me how i can call getFieldValue and pass it the data
> > > of interests ?
>
> > > Thanks.- Hide quoted text -
>
> > - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
