Dave Watts wrote:
> It's worked fine for me with ODBC and JDBC. The INSERT doesn't return a
> recordset, the SELECT does. I may well have just been extremely lucky,
> I guess, but I wouldn't think this is required. You are aliasing the
> @@IDENTITY value, right?
Dave:
Yes, aliasing it as follows:
SELECT ThisID = @@IDENTITY
And then after the CFQUERY ends, just using queryName.ThisID.
Also, I don't think the problem has to do with a returned record set but
with SQL Server returning some other meta-data and information (i.e., X rows
inserted/affected, etc.).
--
Mosh Teitelbaum
evoch, LLC
WWW: http://www.evoch.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292152
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
