. You never know when your table may
have an underlying insert trigger….
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of
Paul Kukiel
Sent: Friday, 13 August 2010 5:27 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] CF8 and MSSQL 2005/2008
Steve don't use
:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com]
*On Behalf Of *Paul Kukiel
*Sent:* Friday, 13 August 2010 5:27 PM
*To:* cfaussie@googlegroups.com
*Subject:* Re: [cfaussie] CF8 and MSSQL 2005/2008
Steve don't use @@identity you can achieve this result with CF alone:
http
*From:* Paul Kukiel [mailto:kuki...@gmail.com]
*Sent:* Monday, 16 August 2010 8:42 AM
*To:* cfaussie@googlegroups.com
*Subject:* Re: [cfaussie] CF8 and MSSQL 2005/2008
I agree. Where we are not using result attribute on older
...@googlegroups.com] On Behalf
Of Steve Onnis
Sent: Monday, 16 August 2010 12:54 PM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] CF8 and MSSQL 2005/2008
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
Is there an updated driver for SQL Server? I have come across this issue
where if i run this query:-
cfquery datasource=ds name=qInsert
INSERT
INTO TableName (Col1)
VALUES ('foobar')
SELECT @@IDENTITY AS 'NewID'
/cfquery
Under CF8 it errors saying qInsert is undefined but under CF9 it runs
Steve don't use @@identity you can achieve this result with CF alone:
http://cookbooks.adobe.com/post_Getting_the_ID_of_the_Last_Record_Inserted_Into_a-16522.html
http://cookbooks.adobe.com/post_Getting_the_ID_of_the_Last_Record_Inserted_Into_a-16522.htmland
with CF9 its more generic:
Yeah, I'm very sure there's been an update on the JDBC drivers from CF 8 to CF
9.
Is there an updated driver for SQL Server? I have come across this issue
where if i run this query:-
cfquery datasource=ds name=qInsert
INSERT
INTO TableName (Col1)
VALUES ('foobar')
SELECT @@IDENTITY