More CF9 ORM help, please
Good Day,
I have these two table, a user table which hold a user info, and then a friends table which will hold 2 user IDS. But I do not think I have it set up right, as I can not get to the data in the friends table.
Please advise on how to do this.
Many thanks.
<cfcomponent hint="I hold the general info" output="false" persistent="true">
<cfproperty name="GenInfoID" hint="The id for the " type="numeric" fieldtype="id" datatype="integer" generator="identity">
<cfproperty name="Name" hint="name of the " type="string" length="255">
<cfproperty name="UserID" singularname="UserID" fieldtype="one-to-many" cfc="KnownAssociates" fkcolumn="GenInfoID"/>
<cfproperty name="KnownAssociate2" singularname="KnownAssociate2" fieldtype="one-to-many" cfc="KnownAssociates" fkcolumn="GenInfoID"/>
</cfcomponent>
<cfcomponent persistent="true">
<cfproperty name="KnownAssociatesID" hint="The id for the Known Associates" type="numeric" fieldtype="id" datatype="integer" generator="identity">
<cfproperty name="GenInfoID" singularname="GenInfoID" fieldtype="many-to-one" cfc="GenInfo" fkcolumn="GenInfoID"/>
<cfproperty name="GenInfoID2" singularname="GenInfoID2" fieldtype="many-to-one" cfc="GenInfo" fkcolumn="GenInfoID2"/>
</cfcomponent>
