There is a typo here. Do you have a table named port_groups_entity, sport_groups_entities? The errors should be followable.
array('table' => 'port_groups_entity',
You also seem to be using some odd names on your tables. I try to always avoid using two plurals unless that table is a join table (habtm) for two other tables. If I do has association through tables, I name that table logically for the relationship that it has. Such as students, classrooms, has a join table enrollments that has extra data based the many to many.
You should debug($var) on all of your variables to see what is actually there.
On Sun, Feb 5, 2012 at 1:41 PM, Team Kemster <kundeservicekemster@gmail.com> wrote:
Hi Stephen,
Thank you for your answer.
Well I would say you are right, if it wasn't for that I am able to
use both the tables for it's self. But joining them gives the problems.
I also tried to use some examples on binding the tables with a model for both tables, but no luck.
Yes, the table has "name" for a column (tables shown in first mail).
Is the pull out in the ctp files correct?
/TheMuller
Den 05/02/2012 kl. 18.54 skrev Stephen Speakman <stephen@ninjacodermonkey.co.uk>:
> Hi
>
> I may not know the answer to your question but shouldn't your model be named:
>
> sport_group.php and SportGroup extends AppModel ?
>
> port_groups_entity table should be named "port_group_entities" ---- PortGroupEntities
>
> I would personally correct all the filenames, class names and $this->Model lines etc to represent proper CakePHP conventions, then I would use pr($this->SportGroup->findByUrl($url)); etc to view the results retrieved from the query...
>
> If name isn't in there maybe it's an error with your MySQL table? Maybe check recursive? (Apologies if I missed any info, my thunderbird client isn't threading mail list topics =/)
>
> Kind Regards
> Stephen
>
>
> On 05/02/2012 17:18, TheMuller wrote:
>> Hi,
>>
>> I have looked, search and founded, but not the answer to my questions:
>> How do I get the result of my join table in my view.ctp? Am I doing
>> something wrong?
>>
>> I have followed some guides from bakery and other blogs, and created a
>> setup like shown below. But why does the error in view.ctp say:
>> "Notice (8): Undefined index: name"
>>
>> Code:
>>
>> models/sportsgroup.php
>> <?php
>> class SportsGroup extends Appmodel {
>> var $name = 'SportsGroup';
>> }
>> ?>
>>
>> controllers/sports_groups_controllers.php
>> <?php
>>
>> class SportsGroupsController extends AppController {
>> var $helpers = array ('Html', 'Form', 'Js' => array('Jquery'),
>> 'Javascript', 'GoogleMapView');
>> var $name = 'SportsGroups';
>>
>> function index() {
>> $this->SportsGroup->recursive = 0;
>> $this->set('sportsgroups', $this->SportsGroup->find('all',
>> array('joins' => array(
>> array(
>> 'table' => 'port_groups_entity',
>> 'alias' => 'GroupsEntity',
>> 'type' => 'inner',
>> 'conditions'=> array('SportsGroup.group_id =
>> GroupsEntity.guid')
>> )
>> )
>> )));
>> $this->set('title_for_layout', 'Sportsclubs online');
>>
>> }
>> function view($url = null) {
>> if (!$url) {
>> $this->Session->setFlash('Invalid id for Post.');
>> $this->redirect('/sportsclub/');
>> }
>> $this->set('post', $this->SportsGroup->findByUrl($url));
>> }
>> }
>>
>> ?>
>>
>> view/sportsgroups/index.ctp (or view.ctp)
>> <?php foreach ($sportsgroups as $post): ?>
>> <?php echo $post['SportsGroup']['title']?> (it catches this one)
>> <?php echo $post['SportsGroup']['name']?> (but not this one)
>> <?php endforeach; ?>
>>
>> view/sportsgroups/view.ctp
>> <?php echo $post['SportsGroup']['title']?> (it catches this one)
>> <?php echo $post['SportsGroup']['name']?> (but not this one)
>>
>> The database table are like:
>> sports_groups: id | group_id | title
>> groups_entity: guid | name
>>
>> Please help me, I used 2-3 days on this one..
>>
>> /TheMuller
>>
>
> --
> 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
--
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
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
No comments:
Post a Comment