Follow up... updates works, selects work. I dont 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:314715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4