ColdFusion 9 ORM and a serious bug with validateparams

Tags: Coldfusion, CFORM

I have actually come across this problem once before, however it was under different circumstances.

In this example I was looking for a way to validate with a regular expression, and dug into the documentation to find a solution. Now before I describe this problem, lets have a look at the scenario to help describe what is happening here.

In the Application.cfc I have the ORMSettings set up so that the database tables are dropped and then recreated, this works fine with the following code.

adminRole = new role(roleName:'administrator').save();
authorRole = new role(roleName:'author').save();
// Create new Space
space1 = new Space(name: 'Andrew Scott', uniqueUrl: 'andrewscott').save();
account = new account(username:'andrews', password:'password', space: space1).save();
account.AddRole(adminRole);
account.AddRole(authorRole);
space1.setClaimedBy(claimedby: account.getUsername());

Now to add the code needed to do what I want from the validation, I needed to make a change to the entity to set the validation params.

property name="uniqueUrl" ormtype="string" fieldtype="id" validate="regex" validateparams="{pattern=[a-zA-Z_0-9\-]+}";

However once I added this line of code, deleted the tables manually and restarted the ColdFusion Application server. I got a very unexpected error.

Once that extra attributes went onto the property tag for validation, it will always throw an error that it is trying to duplicate the data for the role#administrator.

For the life of me I can't work this one out, and yet if I remove the 2 attributes for the validation on the entity and manually delete the tables and restart ColdFusion it all works again.

As I said I have seen this error before, and it was something similar to this. All I can say is that is a very frustrating error.


TweetBacks


Comments (Moderated) | Add Comment

There are no comments for this entry.