I recently(in the past couple of weeks) set up a database called CFVARS to store all our client variables. It's a repository for client variable of 4 sites with different cfapplication names. A user recently received an error(below) that a duplicate key row is trying to be inserted. Could anyone give me any insite on what's stepping on what and why it would do this and also how to prevent it. Thanks so much, and any help greatly appreciated. Here's the error: -------------------------------------- Error Occurred While Processing Request Error Diagnostic Information 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: 03/19/02 09:14:37 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.40.254.98 Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
