Something is not right there.... (scracthing head...) There! It should be Event.person_id = Person.id... shouldn't it? You don't have a Person.event_id field in your database, as far as I can see... What relationship are you using on your models? Maybe you should change the $hasOne to $hasMany or vice-versa.
Regards, - LS On Sep 5, 2:51 pm, "SIXS" <[EMAIL PROTECTED]> wrote: > Hi, > re > when I run my events relating to people, i get this output > I made the changes as suggested by Jon Bennett and Daniel and others. I thank > them for their help. What I want is the person showing and all the events old > and ability to add others. > Thanks > Jim > ================================= > Query: SELECT `Event`.`id`, `Event`.`subject_id`, `Event`.`person_id`, > `Event`.`actualdate`, `Event`.`description`, `Event`.`good`, `Person`.`id`, > `Person`.`lastname`, `Person`.`firstname`, `Person`.`midname`, > `Person`.`prefix`, `Person`.`sex`, `Person`.`birthdate`, > `Person`.`deathdate`, `Person`.`spouseid`, `Person`.`street`, > `Person`.`city`, `Person`.`state`, `Person`.`zip`, `Person`.`email`, > `Person`.`phone`, `Person`.`fax` FROM `events` AS `Event` LEFT JOIN `people` > AS `Person` ON (`Person`.`event_id` = `Event`.`id`) WHERE 1 = 1 > Warning: SQL Error: 1054: Unknown column 'Person.event_id' in 'on clause' in > C:\VertrigoServ\www\kake\cake\libs\model\datasources\dbo_source.php on line > 463 > > CakePHP Rapid Development > List Events > Id Subject Id Person Id Actualdate Description Good Actions > > a.. New Event --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
