They do all have different names. Thanks -----Original Message----- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 10:10 AM To: CF-Talk Subject: RE: Database storage of client variables
Have all of your Application.cfm's have different names for the Application? -----Original Message----- From: Teel, C. Doug [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:08 To: CF-Talk Subject: Database storage of client variables 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). ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
