If athID is your primary key, have you set Identity to 'yes'? (This will "autonumber" your records.) HTH D
************************ Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 -----Original Message----- From: CF_JONNY [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 6:48 PM To: CF-Talk Subject: SQL>>>HELP QUICK! What does this mean? Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'athId', table 'blah.dbo.blah'; column does not allow nulls. INSERT fails. Do I need to set the Primary Key in SQL? I cannot get the entry to give the auto number.. JON _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
