Here's another problem I've run into with ColdFusion's ORM (there seem to be a few of these recently...).
I've only just started running a CF dev environment under Apache on my Mac - I was previously running IIS under VMWare. The problem comes when using Apache's mod_rewrite for URL rewriting.
In my CF9 ORM application, I have a magazine object. Each magazine has a single genre (e.g. Craft, Sports, etc.) - so I have a many-to-one relationship set up on the magazine.cfc:
component output="false" persistent="true"
{
// identifier
property name="magazineid" fieldtype="id" setter="false" generator="identity";
// properties
property name="title";
property name="genre" cfc="genre" fieldtype="many-to-one" fkcolumn="frn_genreid";
}The genre.cfc looks like this:
component output="false" persistent="true"
{
// identifier
property name="genreid" fieldtype="id" setter="false" generator="identity";
// properties
property name="genre";
property name="magazines" cfc="magazine" fieldtype="one-to-many" fkcolumn="frn_genreid";
}It all works nicely, until I want to try removing the genre from the magazine.
My new project is using CF9's ORM, FW/1 and ValidateThis, all for the first time - so naturally I'm having to work a few things out. There will probably be a few posts like this one over the next few weeks...
I have a user edit page, on which you can edit your personal details and change your password. It's set up something like this:
Typically, the very first time I tried to use CF9's ORM, I ran into a bizarre problem which had me scratching my head for hours...
The setup was this: a table in my SQL database called "member". A member.cfc object with the following code:
component output="false" persistent="true"
{
property name="memberid" fieldtype="id";
property name="firstname";
property name="lastname";
}