Hi Cameron,
Below is a snippet of code, and appreciate your assistance in this matter...
<cfcomponent hint="clients CFC" output="false" persistent="true"
table="clients" entityname="Clients">
<cfcomponent hint="clients CFC" output="false" persistent="true"
table="clients" entityname="Clients">
<cfproperty
name="ClientID"
hint="id for clients"
type="numeric"
required="true"
fieldtype="id"
generator="identity"
ormtype="integer"
notnull="true">
<cfproperty
name="UsersObj"
fieldtype="one-to-many"
linktable="ClientUser"
type="array"
cfc="users"
inverse="true"
cascade="all-delete-orphan"
fkcolumn="clientid"
inversejoincolumn="userid"
lazy="false"
singularname="UsersObj">
<cfproperty
name="UserroleObj"
fieldtype="one-to-many"
linktable="ClientUserRole"
type="array"
cfc="userrole"
inverse="true"
cascade="all-delete-orphan"
fkcolumn="clientid"
inversejoincolumn="userroleid"
lazy="false"
singularname="UserroleObj">
<cfproperty
name="clientname">
<cfproperty
name="isactive">
<cfproperty
name="departmentname">
<cfproperty
name="departmentaddress">
<cfproperty
name="contactname">
<cfproperty
name="contactemail">
<cfproperty
name="contacttelephone">
<cfproperty
name="accounttype">
<cfproperty
name="startdate">
<cfproperty
name="expirydate">
<cfproperty
name="paymentmethod">
<cfproperty
name="notes">
-------------------------------------------
<cfcomponent hint="users CFC" output="false" persistent="true" table="users"
entityname="Users">
<cfproperty
name="userid"
hint="id for users"
type="numeric"
required="true"
fieldtype="id"
generator="identity"
ormtype="integer"
notnull="true">
<cfproperty
name="email">
<cfproperty
name="password">
<cfproperty
name="title">
<cfproperty
name="firstname">
<cfproperty
name="lastname">
<cfproperty
name="position">
<cfproperty
name="isactive">
<cfproperty
name="userroleid">
<cfproperty
name="showassistance">
<cfproperty
name="failedloginattempts">
<cfproperty
name="passwordexpires">
<cfproperty
name="ClientsID"
fieldtype="many-to-one"
linktable="ClientUser"
fkcolumn="userID"
inversejoincolumn="clientID"
cfc="clients"
singularname="Clients">
</cfcomponent>
-------------------------------------------
<cfcomponent hint="user role CFC" output="false" persistent="true"
table="userrole" entityname="Userrole">
<!--- define the user role properties --->
<cfproperty
name="userroleid"
hint="id for user role"
type="numeric"
required="true"
fieldtype="id"
generator="identity"
ormtype="integer"
notnull="true">
<cfproperty
name="rolename">
<cfproperty
name="ClientsID"
fieldtype="many-to-one"
linktable="ClientUserRole"
fkcolumn="userroleid"
inversejoincolumn="clientID"
cfc="clients"
singularname="Clients">
</cfcomponent>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349070
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
