Is your primary key for the table a composite of the cfid and app fields? Or did you just set cfid to the primary?
I've run cdata with the composite index described above (I believe this is the ''right'' way to do it) and where the cfid field is a simple index and there is no primary key defined. CF 4.5x actually creates the CDATA table completely without indexes on an Access table set. All of the above have worked fine for me over extended periods. Looks like it does the same thing in SQL Server as it does for Access, from the test I just ran, although I'm not so familiar with that platform to say absolutely for sure I know what I'm looking at in the Enterprise Manager. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 8: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). ______________________________________________________________________ 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
