debug($patient) produces:
Array
(
[Patient] => Array
(
[id] => 5007
[med_hist_id] => 0
[gender] => M
[st_of_birth] => [redacted]
[st_of_res] => [redacted]
[res_length] => 11 yrs
[cntry_of_origin] => U.S.
[dob] => [redacted]
[siblings] => 2
[birth_order] => 1
[mono_before] => N
[ethnicity] => [redacted]
[race] => [redacted]
[contact_by] => email
[withdrawn] => N
[kdas] => NKDA
[mono_dx] => N
)
[Visit] => Array
(
[0] => Array
(
[id] => 2060
[quest_id] =>
[patient_id] => 5007
[protocol] => Mono 5
[vdate] => 4/22/2008
[vtmstmp] => 1208840400
[week] =>
[yr] => 2
[number] => 8
[notes] => [redacted]
[kit] => 0
[sev_p] => 0
[sev_scr] => 0
[sev_pain] =>
[modified] => 4/22/2008 2:25:47 PM
[created] => 4/22/2008 2:11:39 PM
)
//truncated here, but shows the last ten visits as expected
)
[M5Symptom] => Array
(
[0] => Array
(
[id] => 19
[patient_id] => 5007
[symptom] => Stuffy Nose
[start_date] => 12/18/2006
[end_date] => 12/21/2006
[severity] =>
[exported] =>
[date_reported] =>
[created] =>
[modified] =>
)
// again truncated by me, but the list of 25 shows up in the array
)
)
On May 15, 12:23 pm, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> Hi Tony,
> What do you have in the $patient variable when you debug it?
> debug($patient)
>
> /Martin
>
> On May 15, 5:37 pm, Tony Thomas <[EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
