Yup, spot on Leigh, they're not working right with the jDTS driver either :O
Wrapping the whole statement with BEGIN .. END, or indeed SET NOCOUNT ON/OFF does make them work though. Looks like I'm going to have to bite the bullet and get coding; the performance issues with the default CF driver are too big to ignore, unfortunately. Thanks Dominic On 1 February 2010 15:03, Leigh <cfsearch...@yahoo.com> wrote: > > You may also want to check for multiple queries with @@IDENTITY and > SCOPE_IDENTITY(). I remember seeing very different (and sometimes bizarre) > results with CF8 across the different drivers. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4