hi Jim,
How are your associations setup? They should be:
class Person {
var $hasMany = array('Event');
}
class Event {
var $belongsTo = array('Person');
}
hth
jon
On 05/09/07, 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
>
> New Event
>
> >
>
--
jon bennett
w: http://www.jben.net/
iChat (AIM): jbendotnet Skype: jon-bennett
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
