Hi All, I'm building a CakePHP app for tracking clinic patients, their visits, their symptoms and questionnaire answers. The barrier I've encountered is that each patient has many visits AND many symptoms. I want to view the patient record and their aggregate visits and symptoms.
I've defined a hasMany relationship in the patient model as such: var $hasMany = array( 'Visit' => array( 'order' => 'Visit.id DESC', 'limit' => '10' ), 'M5Symptom' => array( 'className' => 'M5Symptom', 'order' => 'M5Symptom.modified DESC', 'limit' => '25' ) ); In the patient view I get the relevant patient data, and the corresponding list of visits, but I get the message, "Undefined index: M5Symptom" for listing the symptoms. As far as I can tell the model is correct, because the query for the patient view finds and retrieves a list of 25 symptom records exactly as specified in the model. From that I take that the model and controller must be working as expected. Otherwise the query wouldn't be right and/or it wouldn't retrieve the pertinent records. The query that results is EXACTLY what I want. That leads me to believe the problem must be in the view. Here's the view function in the patient controller: function view($id = null) { $this->Patient->id = $id; $this->set('patient', $this->Patient->read()); } Everything works right up until I try to list the symptoms. Here's the code for listing symptoms in the view: echo $html->tableHeaders(array('Symptom','Start Date','End Date', 'Severity')); foreach ($patient['M5Symptom'] as $symptom) { echo $html->tableCells( array($symptom['symptom'], $symptom['start_date'], $symptom['end_date'], $symptom['severity'], ) ); } I've looked at all of this over and over and I just can't find out why 'M5Symptom' is undefined. Just above this, 'Visit' lists recent visit dates for me with the exact same logic in place. Am I wrong in assuming I can define more than one hasMany? If so, why is the correct query generated? I'm hoping another set of eyes will find what I'm missing. Sleeping on it didn't help. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---