We just updated to Windows Server 2012 r2, SQL Server 2013, and ColdFusion 11 from ColdFusion 8. Now our updates using CFQUERY don't seem to work using:
AND ONLINE = 1
Looks like we are now required to use:
AND ONLINE = 'True'
Looks like we need to change all our code to reflect that change using Dreamweaver, and gang change from one command, a bit precarious for me, but I'm in the process of doing so.
I'd just like some confirmation of this SQL change and any discussion about it, or what to avoid, what may or may not be correct and any suggestions anyone may have about this change using ColdFusion to update and insert date into the new SQL Server.