Sandra Clark wrote:
> Actually if you are using MSSQL 2000 or 2005 or up, you should be using
>
> VALUES();
> SELECT SCOPE_IDENTITY() AS id
>
Okay, I just added this to my insert function, and got this:
[Macromedia][SQLServer JDBC Driver][SQLServer]'SCOPY_IDENTITY' is not a
recognized built-in function name.
Here's the exact line:
);
select SCOPY_IDENTITY() as newuserid
</cfquery>
Rob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311270
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
