have you upgraded your database server recently. ISTR that you have to use scope_identity on SQL2008 and the old reference no longer works.
Russ On Tue, Jul 26, 2011 at 12:15 PM, Brian Polackoff <bpolack...@gmx.com>wrote: > > Has anyone ever run into "identitycol" is undefined while using the result > attribute in a cfquery while using cf8 enterprise on a windows 2k8 and a SQL > 2005 server? > > This problem started on Sunday in our production environment. We have > rebooted the database server and the web servers with no effect. > > Any help would be appreciated otherwise we we will recode all to use sqls's > "scope_identity" > > Thanks, > Brian > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm