AH.... I exported the table and re-imported it and the identity switch got changed to "No".
Now it works. > -----Original Message----- > From: Chad Gray [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 01, 2008 11:50 AM > To: cf-talk > Subject: RE: insert error > > Follow up... updates works, selects work. I don't know why the insert is > failing. > > > -----Original Message----- > > From: Chad Gray [mailto:[EMAIL PROTECTED] > > Sent: Saturday, November 01, 2008 11:42 AM > > To: cf-talk > > Subject: insert error > > > > What is up with this? > > > > How can an insert fail with this error? > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value > > NULL into column 'PageID', table 'SocialCards4You.dbo.Pages'; column > > does not allow nulls. INSERT fails. > > > > PageID is an autoincrementing column in my MS SQL database. Here is my > > insert code. > > > > INSERT Pages (Name, Alias, PageContent, Live) VALUES ( (param 1) , > > (param 2) , (param 3) , (param 4) ) > > > > The only thing I have changed on this app is I switched to and > > application.cfc that captures the error and emails me. The other > > strange part is I do a cfinclude to include and error.cfm page and it > > does not display either. > > > > This is CF7 also. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4