search

deanlaw / cfcgenerator

Automatically exported from code.google.com/p/cfcgenerator
8 stars 6 forks source link

Datefield forgets time #53

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
If I have a date field in my MSSQL table, the cfcgenerator params the DAO 
query with cfsqltype date.
The problem is when you want to input a datetime, the query "forgets" the 
time and just adds 12:00:00 as the time in stead of the time I have set in 
the object.
The Getters return the correct value, the problem lies in inserting the 
value in the database.

The way to solve this is to use the cfsqltype timestamp.

Original issue reported on code.google.com by jorrit.j...@gmail.com on 27 Aug 2007 at 1:16

GoogleCodeExporter commented 9 years ago 
I suspect we need to change
            <cfcase value="datetime">
                <cfreturn "date" />
            </cfcase>
in mssql.cfc (line 146-ish).

Could you test that for us ?

Original comment by tom.chiv...@gmail.com on 13 Oct 2010 at 3:03