cf-orm

How to map this link table in cf-orm?

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

Cleanest way to log who updated what in CF-ORM / Hibernate?

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

bi-directional o2m/m2o beats uni-directional o2m in SQL efficiency?

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

Things to watch out for in ColdFusion 9 with CF-ORM

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?

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