As we recently tried to migrate a Coldfusion 7 Project to Coldfusion 9.0.1 we noticed that obviously variables handling in Microsoft SQL Server JDBC interface has changed.
We performed these few tests for example – each of it separatly – and always got the same result:
INSERT INTO [mytable] ([datefield]) values (#createODBCDateTime(now())#) INSERT INTO [mytable] ([datefield]) values (#now()#) UPDATE [mytable] SET [datefield] = #createODBCDateTime(now())# UPDATE [mytable] SET [datefield] = #now()#
The error Coldfusion gave us was a SQLServer JDBC error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Bei der Konvertierung eines varchar-Datentyps in einen smalldatetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
