Thanks Ben. Its fixed. The table was imported to another server and it did not save the ID field as primary/identity YES. It was set to NO. I reset and it worked. But its shows not to assume the import will copy everything exactly.
Robert O. -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 12:24 PM To: CF-Talk Subject: RE: Insert fails? Is it marked as the Primary Key... Try marking it as the primary key of the table as well. ........................ Ben Nadel www.bennadel.com -----Original Message----- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 12:04 PM To: CF-Talk Subject: Insert fails? When I insert info into my dbase I get an insert fails error. See below. Cannot insert the value NULL into column 'ID', table 'pc_inventory.dbo.inventory'; column does not allow nulls. INSERT fails. The ID filed is setup as an Identity field in SQL. Any ideas please? Seems simple, but I'm stuck in neutral here. Thanks. Insert code is: <CFQUERY name="inventory" datasource="pc_inventory"> INSERT INTO inventory ( department, floor, lname, fname, pcname, phone, password, pcmodel, workgroup, ip, printerip, printer, serialnumber, port, switchport, oldpcnumber, newpcnumber, comments) VALUES ( '#FORM.department#', '#FORM.floor#', '#FORM.lname#', '#FORM.fname#', '#FORM.pcname#', '#FORM.phone#', '#FORM.password#', '#FORM.pcmodel#', '#FORM.workgroup#', '#trim(FORM.ip)#', '#FORM.printerip#', '#FORM.printer#', '#trim(FORM.serialnumber)#', '#FORM.port#', '#FORM.switchport#', '#trim(FORM.oldpcnumber)#', '#trim(FORM.newpcnumber)#', '#FORM.comments#') </CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246913 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
