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:246906 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
