Hi I'm a noobie with CF and ORM. I'm using SQL Server 2008
I have a test CF app, and I have the ormSettings.dbcreate set to "update",
like so:
this.ormSettings = {
datasource = "dsn",
dbcreate = "update",
schema = "dbo",
logsql = true
};
Here's my Account.cfc
component persistent="true" {
property name="id" column="AccountID" generator="identity";
property name="username";
property name="password";
property name="datecreated";
}
Here's my test.cfm, in cfscript:
ormReload()
x = new Account();
x.setUsername("user1");
x.setPassword("pw1");
entitySave(x);
It was working at first, so I decided to delete the database from the SQL
side (via Management Studio).
So now, when I reload test.cfm, I get this error:
Error in executing the DDL.[Macromedia][SQLServer JDBC
Driver][SQLServer]Identity column 'AccountID' must be of data type int,
bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and
constrained to be nonnullable.
I tried changing dbcreate to "dropcreate", and I get the same error, but
this new message is there as well:
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot drop the table
'dbo.Account', because it does not exist or you do not have permission.
How do I get it working again? I tried restarting the service, but that did
not help. I even recreated the table, and CF dropped it but I still get the
"Error in executing the DDL" error.
Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:341870
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
