Ticket #18 (closed defect: fixed)
Datatype "Time" Unsupported
| Reported by: | thegoosmans@… | Owned by: | dhughes |
|---|---|---|---|
| Type: | defect | Priority: | normal |
| Milestone: | Beta | Component: | Reactor - DBMS Interfaces |
| Version: | Severity: | normal | |
| Keywords: | Cc: |
Description
One of the columns in my MySQL InnoDB table has the datatype of Time, and I'm getting this error from Reactor:
"Unsupported (or incorrectly supported) database datatype: time."
It seems that the function getCfSqlType in reactor/data/mysql/ObjectDao doesn't have a case for the Time datatype. There is a proper type for ColdFusion that can be used: cf_sql_time.
I added this code and the problem was fixed.
<cfcase value="time"> <cfreturn "cf_sql_time" /> </cfcase>
Change History
Note: See
TracTickets for help on using
tickets.
