I have seen similar behaviour, I think it was with CF 8.
Using the Set nocount on option seemed to help.
cfquery datasource=ds name=qInsert
set nocount on
INSERT
INTO TableName (Col1)
VALUES ('foobar')
SELECT @@IDENTITY AS 'NewID'
Set nocount off
/cfquery
PS: SCOPE_IDENTITY() is a better
I agree. Where we are not using result attribute on older code we use
scope_identity() without issues on CF8 and we have never changed drivers.
Paul.
On 16/08/2010 8:02 AM, Scott Thornton wrote:
I have seen similar behaviour, I think it was with CF 8.
Using the Set nocount on option seemed
We only use 2005 and 2008. Both methods work for me I'll assume 8.01
and all updates have been applied?
Paul.
On 16/08/2010 12:54 PM, Steve Onnis wrote:
what version of SQL though? I havent had any issues with it either
till i started using SQL2005
the SET NOCOUNT ON/OFF seems to work
Steve,
As far as I know this setting is not on my default, and as the setting means
it will not return the number of rows affected.
Regards,
Andrew Scott
http://www.andyscott.id.au/ http://www.andyscott.id.au/
From: cfaussie@googlegroups.com
Monday 30th August, 6pm for 6:30 start
With Adobe and third party tool developers increasingly use Eclipse as
a platform for creating development tools like Flash Builder,
Coldfusion Builder, Flash Catalyst, LiveCycle Services Discovery
Plugin, Adobe Application Modeling Plugin, CFEclipse, FDT,