Skip to main content
P
paule1234
Known Participant
May 28, 2010
Question

CF9 IDENTITYCOL bug?

  • May 28, 2010
  • 1 reply
  • 992 views

This one is hard for us to reproduce...  we recently upgraded from CF8 Enterprise to CF9 Enterprise (version 9,0,0,251028), connected to a SQL Server 2005 SP3 database (version 9.0.4053) ... we have a CFQUERY that does an INSERT and is occassionally failing to return an IDENTITYCOL in the result structure.  The record is correctly inserted into the table and no error is thrown by the CFQUERY.  The datasource is using the Microsoft SQL Server driver.

The OS is 32-bit Windows 2003 SP2 Enterprise.

This topic has been closed for replies.

1 reply

M
Mr_Vball
Participating Frequently
July 14, 2010

Has anyone found a solution to this? We are running into the same issue using the same version of CF9 on SQL 2000. It is very hard to diagnose because it happens intermittenly.

TIA

P
paule1234Author
Known Participant
July 14, 2010

FWIW, I ended up changing my code to the "old fashioned" SELECT @@IDENTITY AS new_id technique in order to eliminate the errors on our CF9 system.

-
-__cfSearching__-
Inspiring
July 29, 2010

Generally SCOPE_INDENTITY() should be used instead of @@IDENTITY

http://msdn.microsoft.com/en-us/library/ms190315.aspx

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices