tracker issue : CF-3040670

select a category, or use search below
(searches all categories and all time range)
Title:

Bug 81322:Cannot use 2 FK's as composite PK's in a link table cfc

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Henry Ho / Henry Ho (Henry Ho)

Created: 12/23/2009

Components: ORM Support

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Platforms All

Vote Count: 0

Problem:

Cannot use 2 FK's as composite PK's in a link table cfc. 
Method:

component persistance="true" displayname="invoiceItem" table="INVOICE_ITEM"{  property name="invoice" fieldtype="many-to-one" fkcolumn="invoiceID" cfc="invoice";  property name="item" fieldtype="many-to-one" fkcolumn="itemID" cfc="item";  property name="price" type="numeric";}// CF will ask for an ID column, but want to use invoiceID & itemID as composit PK.
Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3040670

External Customer Info:
External Company:  
External Customer Name: Henry Ho
External Customer Email: 237A22C24921EDF5992015B9
External Test Config: 12/23/2009

Attachments:

Comments: