hmmm ok Ill refactor my schema.xml and see what happens.... :) all good fun!
On 19/03/2007, at 5:00 PM, Ant Cunningham wrote: > > could be... I usually use creator_id or owner_id when implementing > things > like that. > > > On 3/19/07 12:57 AM, "Craig Boxall" <[EMAIL PROTECTED]> wrote: > >> >> I think it may have something to do with the fact that I have named >> the column created_by instead of something like user_id >> What do you think? >> >> >> On 19/03/2007, at 4:33 PM, Sid Bachtiar wrote: >> >>> >>> Ok, from the schema I think $project->getUser()->getNameFirst() >>> should >>> really work. >>> >>> Unless $project isn't an object in the first place since you said: >>> >>>>>>> $project->getCreatedBy()->getFirstName() >>>>>>> >>>>>>> But this gives me a cannot call method on non-object error. >>> >>> which could mean that $project isn't an object in the first place. >>> >>> A little snippet of where you put that line might be useful to >>> determine the problem. >>> >>> On 3/19/07, Craig Boxall <[EMAIL PROTECTED]> wrote: >>>> >>>> <table name="user" phpName="User"> >>>> <column name="id" type="integer" >>>> required="true" primaryKey="true" >>>> autoIncrement="true" /> >>>> <column name="uname" type="varchar" >>>> size="15" /> >>>> <column name="pword" type="varchar" >>>> size="100" /> >>>> <column name="user_group_id" >>>> type="integer" default="0" /> >>>> <foreign-key foreignTable="user_group"> >>>> <reference local="user_group_id" >>>> foreign="id"/> >>>> </foreign-key> >>>> <column name="name_first" type="varchar" >>>> size="100" /> >>>> <column name="name_last" type="varchar" >>>> size="100" /> >>>> <column name="email" type="varchar" >>>> size="100" /> >>>> <column name="position" type="varchar" >>>> size="100" /> >>>> <column name="phone_1" type="varchar" >>>> size="20" /> >>>> <column name="phone_2" type="varchar" >>>> size="20" /> >>>> <column name="created_at" >>>> type="timestamp" /> >>>> <column name="updated_at" >>>> type="timestamp" /> >>>> <column name="logged_at" >>>> type="timestamp" /> >>>> <column name="created_by" type="integer" /> >>>> <column name="updated_by" type="integer" /> >>>> <column name="is_active" type="tinyint" >>>> size="1" /> >>>> <column name="is_deleted" type="tinyint" >>>> size="1" /> >>>> </table> >>>> >>>> <table name="project" phpName="Project"> >>>> <column name="id" type="integer" >>>> required="true" primaryKey="true" >>>> autoIncrement="true" /> >>>> <column name="jobnum" type="varchar" >>>> size="6" /> >>>> <column name="client_id" type="integer" /> >>>> <foreign-key foreignTable="client"> >>>> <reference local="client_id" >>>> foreign="id"/> >>>> </foreign-key> >>>> <column name="title" type="varchar" >>>> size="100" /> >>>> <column name="description" type="varchar" >>>> size="255" /> >>>> <column name="created_at" >>>> type="timestamp" /> >>>> <column name="updated_at" >>>> type="timestamp" /> >>>> <column name="created_by" type="integer" /> >>>> <foreign-key foreignTable="user"> >>>> <reference local="created_by" >>>> foreign="id" /> >>>> </foreign-key> >>>> <column name="updated_by" type="integer" /> >>>> <foreign-key foreignTable="user"> >>>> <reference local="updated_by" >>>> foreign="id" /> >>>> </foreign-key> >>>> <column name="duedate" type="timestamp" /> >>>> <column name="is_active" type="tinyint" >>>> size="1" /> >>>> <column name="is_deleted" type="tinyint" >>>> size="1" /> >>>> </table> >>>> >>>> On 19/03/2007, at 4:18 PM, Sid Bachtiar wrote: >>>> >>>>> >>>>> Show us the schema.yml or schema.xml >>>>> >>>>> On 3/19/07, Craig Boxall <[EMAIL PROTECTED]> wrote: >>>>>> >>>>>> Thanks Ant, >>>>>> >>>>>> Yes getCreatedBy() returns the id of the user (which in this >>>>>> case is >>>>>> "1") so myscript echoes >>>>>> "Created by 1" >>>>>> Instead of: >>>>>> "Created by Craig" >>>>>> >>>>>> >>>>>> I tried what you suggest and I get the following error: >>>>>> >>>>>> Call to undefined method Project::getUser() >>>>>> >>>>>> when trying: >>>>>> >>>>>> $project->getUser()->getNameFirst(); >>>>>> >>>>>> Any suggestions? >>>>>> >>>>>> Cheers >>>>>> >>>>>> >>>>>> >>>>>> On 19/03/2007, at 3:52 PM, Ant Cunningham wrote: >>>>>> >>>>>>> >>>>>>> I believe getCreatedBy() is only giving you the ID not the >>>>>>> object >>>>>>> it is >>>>>>> linking to. try using $project->getUser()->getFirstName(); it >>>>>>> seems >>>>>>> odd >>>>>>> because youre not using the default naming pattern (ie. >>>>>>> user_id as >>>>>>> a value >>>>>>> is getUserID(), user as an object is getUser()), the proxy to >>>>>>> get >>>>>>> the >>>>>>> related record is created by the related class name, not the >>>>>>> column >>>>>>> name. >>>>>>> >>>>>>> **I think** >>>>>>> >>>>>>> :-) >>>>>>> >>>>>>> >>>>>>> On 3/18/07 11:11 PM, "Craig Boxall" <[EMAIL PROTECTED]> >>>>>>> wrote: >>>>>>> >>>>>>>> >>>>>>>> Hi everyone, >>>>>>>> >>>>>>>> This is my first post to the symfony group so go easy on >>>>>>>> me :) Im >>>>>>>> also super-new at Symfony and I have what I imagine is a simple >>>>>>>> question. >>>>>>>> >>>>>>>> I have two modules >>>>>>>> >>>>>>>> -> Project >>>>>>>> -> User >>>>>>>> >>>>>>>> One of the fields in my Project table is created_by to store >>>>>>>> the ID >>>>>>>> of the user who created the project. I have set up a foreign >>>>>>>> key to >>>>>>>> link this to the User table. >>>>>>>> >>>>>>>> When creating new records it gives me a drop down of all the >>>>>>>> records >>>>>>>> in my user table (by ID number not name) so I am able to >>>>>>>> capture a >>>>>>>> user just fine. >>>>>>>> >>>>>>>> Now when I list the Projects, I want to be able to do something >>>>>>>> like: >>>>>>>> >>>>>>>> $project->getCreatedBy()->getFirstName() >>>>>>>> >>>>>>>> But this gives me a cannot call method on non-object error. >>>>>>>> >>>>>>>> Any suggestions how I make this work? >>>>>>>> >>>>>>>> Thanks to any help. >>>>>>>> >>>>>>>> regards >>>>>>>> Craig >>>>>>>> >>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>>>> >>>>>> >>>>> >>>>>> >>>> >>>> >>>>> >>>> >>> >>>> >> >> >>> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" 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/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
