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: