I have run into a unique situation, the first time in my 10 years of using CF.
I have a pseudo-fusebox app, and I have an act page we'll call it: act_process.cfm it calls 2 qry files that in turn call one stored proc each. When the act page runs, I have checked the database and all the procs ran and updated the necessary data and inserted the necessary records. However coldfusion throws an error saying that the first proc failed due to a primary key constraint. The 1st proc is the only one that does inserts. I am using ColdFusion 8, and the database is SQL 2008. The error is: [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_mypkname'. Cannot insert duplicate key in object 'dbo.tableA'. Any help would be appreciated. Thanks, Ali ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329626 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
