StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3897265
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-10-09T18:11:48.657
FavoriteCount
0
LastActivityDate
2010-10-09T18:11:48.657
LastEditDate
LastEditorUserId
0
OwnerUserId
1537
ParentId
3868993
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Here are the steps I took to finally get this working correctly. <ol> <li>Be careful of tablename case with ColdFusion/MySql/OS X. It can really kill orm. What happens is that if the wrong case treatment is used in configuring MySql, Orm will drop a table but then be unable to recreate it because MySql still thinks the table exists but with a different case. This can be particularly frustrating as the MySql tools will not actually display the table with the wrong case, but you can still query it. This is a known issue with the MySql team. My advice is to just supply all lowercase names for your tables and to set your MySql table case configuration option to 1 (Store in lowercase, case insensitive). That seemed to work for me.</li> <li>Make sure you set your dialect orm option to "MySQLwithInnoDb"</li> <li>Set ormtype on all keys.</li> <li>Stick with int or integer and use it consistently. I went with integer.</li> <li>Occasionally restart everything/reboot.</li> <li>I took the sqltype off of the foreign key reference in News.cfc</li> </ol> After I did all that, it finally started working as expected. Here is my final News.cfc <pre><code>/** * Theser are the news items on the home page. * @persistent true * @accessors true * @output false * @entityname "News" * @table news */ component { property name="NewsId" type="string" fieldtype="id" ormtype="integer" generator="native" generated="insert"; property name="Teaser" type="string" sqltype="varchar(200)"; property name="Story" type="string" sqltype="varchar(500)"; property name="ProductLine" fieldtype="many-to-one" cfc="ProductLine" ormtype="integer" fkcolumn="ProductLineId" foreignkeyname="fk_productline_news"; } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POColdFusion ORM creates wrong data type
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USanopres
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POColdFusion ORM creates wrong data type
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.