Here is the setup for the persistent cfc's:
categories.cfc
<cfcomponent
displayname="category"
persistent="true"
output="false"
table="category"
entityname="category"
beans="commentGateWay">
<cfproperty name="categoryId" column="id" fieldType="id"
generated="always" generator="increment" displayname="id" ormType="integer"
setter="false"/>
<cfproperty name="description" column="description" default=""
displayname="description" fieldType="column" type="string" />
<cfproperty name="name" column="name" default="" displayname="name"
fieldType="column" type="string" />
<!--- relations --->
<cfproperty
name="message"
fieldType="many-to-many"
cfc="message"
linktable="categoryMessage"
fkcolumn="FK_category"
inversejoincolumn="FK_message"
type="array"/>
message.cfc:
<cfcomponent
displayname="message"
persistent="true"
output="false"
table="message"
entityname="message">
<cfproperty name="messageId" setter="false" column="id" fieldtype="id"
generator="increment" generated="always" type="numeric" />
<cfproperty name="content" default="" displayname="content"
type="string" />
<cfproperty name="date" default="" displayname="date" type="date" />
<cfproperty name="subject" default="" displayname="subject"
type="string" />
<!--- relations --->
<cfproperty
name="categoryArray"
fieldType="many-to-many"
linktable="categoryMessage"
cfc="category"
fkcolumn="FK_message"
inversejoincolumn="FK_category"
inverse="true"
type="array"/>
<cfproperty
name="comments"
fieldType="one-to-many"
cfc="comment"
fkcolumn="commentId"
type="Array"
lazy="true" />
comment.cfc:
<cfcomponent
displayname="comment"
persistent="true"
output="false"
table="comment"
entityname="comment">
<cfproperty name="commentId" column="id" fieldtype="id"
generated="always" generator="increment" ormtype="integer" setter="false"/>
<cfproperty name="subject" default="" displayname="subject"
type="string" />
<cfproperty name="content" default="" displayname="content"
type="string" />
<!--- relations --->
<cfproperty name="message" fieldType="many-to-one" cfc="message"
fkcolumn="messageId" >
--
Model-Glue Sites:
Home Page: http://www.model-glue.com
Documentation: http://docs.model-glue.com
Bug Tracker: http://bugs.model-glue.com
Blog: http://www.model-glue.com/blog
You received this message because you are subscribed to the Google
Groups "model-glue" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/model-glue?hl=en
