2010年5月31日星期一

[fw-db] Duplicate field names in manytomany relationship

I have a table called components with the following fields;

 

id

part_no

description

created_date

modified_date

 

I have another table called nests with the following fields;

 

id

nest_no

description

created_date

modified_date

 

Finally i have a joining table called nestcomponents with the following fields;

 

id

nest_id

component_id

qty

created_date

modified_date

 

I am using the following code to create and return a manytomany recordset;

 

$components = $nest->findManyToManyRowset('Titanium_Model_Components',

                                          'Titanium_Model_NestComponents');

        $this->view->components = $components;

 

How does Zend Framework deal with the duplicated fieldname for id, created_date and modified_date?

Can i use some form of alias for these field names so that i can distinguish between them in the resulting recordset?

 

I particularly need the id of the record in the joining table, however the data returned by id seems to be that of the component table.

Steve



-
Williams Refrigeration is a trading name of AFE Group Limited.
Registered in England & Wales under Registered Number 3872673. Registered
Office Address - Bryggen Road, North Lynn, Industrial Estate, Kings Lynn, Norfolk, PE30 2HZ

Williams Refrigeration filters email attachments for spam and viruses and malicious content with Sophos Puremessage. While every care has been made to ensure that this message is secure and virus free, we cannot be held responsible for any damage arising from computer viruses and advise that you perform your own checks on this and any other inbound messages.

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error or are having trouble sending email to us please notify the system administrator - postmaster@williams-refrigeration.co.uk

Any views or opinions expressed in this e-mail are those of the sender and do not necessarily coincide with those of Williams Refrigeration or the AFE Group.

没有评论: