<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
-~----------~----~----~----~------~----~------~--~---
