If the CDATA table has a key, it must be a composite key on both CFID and APP. Make sure the unique index is on both columns.
Chuck McElwee etech solutions inc www.etechsolutions.com -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 9:54 PM To: CF-Talk Subject: Weird client var error Hi all, I'm getting a weird error on a site. The template in question doesn't do an insert, yet the error below says there's an integrity constraint violation. Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt), ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. Date/Time: 04/11/02 17:58:10 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt) Remote Address: 65.24.161.67 I can only assume that this is a client variable storage error, given that CDATA is the object. Has anyone ever seen this problem with SQL2000 and client vars before? Thanks, Ian ______________________________________________________________________ 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
