Ticket #183 (new defect)

Opened 3 months ago

Last modified 1 month ago

coldfusion.runtime.Cast$DateConversionException: The value could not be converted to a date

Reported by: bwhitehall Owned by: dhughes
Type: defect Priority: normal
Milestone: 1.0 Release Component: Reactor - DAO
Version: 1.0 Severity: normal
Keywords: coldfusion.runtime.Cast$DateConversionException timestamp date Cc:

Description

Error:
Saving a MS-SQL-based record object with a SSMA_Timestamp field generates
coldfusion.runtime.Cast$DateConversionException: The value class [B
could not be converted to a date.."

Example
person = factory.createRecord("person");
person.setName("test");
Person.save(); <--generates error

Thoughts:
SSMA_Timestamp is a timestamp field. According to Adobe docs, MS SQL timestamps should be mapped using cfqueryparam cfsqltype="binary". Instead function "getCfSqlType" maps it to cfsqltype="timestamp".

See http://svn.reactorframework.org/trunk/reactor/data/mssql/ObjectDao.cfc

CF Version: ColdFusion 7 standalone
OS: Windows Server 2000
DB: MS SQL Server 2005

Change History

Changed 1 month ago by mark.drew@…

  • milestone set to 1.0 Release
Note: See TracTickets for help on using tickets.