A 1---* A_B *---1 B
Table A has aID (PK), Table B has bID (PK),
table A_B has:
aID (PK, FK),
bID (PK, FK),
num
I tried
property name="A" fieldtype="many-to-one" cfc="A" fkcolumn="aID";
property name="B" fieldtype="many-to-one" cfc="B" fkcolumn="bID";
property name="num" type="numeric";
but CF keep asking me for an ID column... wha...
One of the requirements of my project is to log who (which Staff) updated what (from what version to what version). UI needs to show who updated entity X at what time and what are updated.
What is the cleanest way to implement this?
For discussion purpose, imagine... Account has a Contact, and I need to store who update the contact, w...
Use these 2 persistent CFCs for example:
// Cat.cfc
component persistent="true" {
property name="id" fieldtype="id" generator="native";
property name="name";
}
// Owner.cfc
component persistent="true" {
property name="id" fieldtype="id" generator="native";
property name="cats" type="array" fieldtype="one-to-many" cfc="cat" casc...
What are some of the things you've observed in ColdFusion 9 with CF-ORM (Hibernate) that one should watch out for?
...
How to cache rarely changed many-to-one entity in CF ORM, such as, userType where there are only < 10 types? I don't want the extra select to get the type name.
EhCache? Any XML needed to be config first? Any thing I need to add in the many-to-one cfproperty?
Thank you.
...