There is a field in the table that is required and does not allow null values. It appears that REVIEW is not the only column in the table into which you are doing the insert.
Check out the structure of the table and see what the columns are that are required in the table. Oh, and make sure that the REVIEW table is not a view into another table. Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Debi Lewis [mailto:[EMAIL PROTECTED] Sent: Thursday, July 06, 2006 12:53 PM To: SQL Subject: Insert trouble: Index or primary key cannot contain a Null value Hi all -- this is my first post, so please let me know if this is the wrong forum. I am doing a simple insert of a long bit of text into an Access memo field (Access is being used at the client's request -- the db already exists in this format). All I want to do is insert a new record into the table. I have a form that collects this text in a textarea, and my insert statement on the processing page is: <cfquery name="insertreview" dataSource = "mydatasource"> INSERT INTO review (review) VALUES ('#form.review#') </cfquery> When I try this, I get Error Executing Database Query. Index or primary key cannot contain a Null value. There is actually no primary key for this table. I can't add one because the db already exists and can't be altered. Any ideas? Thanks in advance, Debi ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
