Well, I guess that's the problem. I was certain there was a cf_sql_datetime (and pretty certain I've been using it for years :) ). I guess I'd expect CF to throw an error for an invalid sql type.
Thanks! Scott On Mon, May 17, 2010 at 7:46 PM, Leigh <[email protected]> wrote: > > > Well, a "timestamp" in mySQL is a bit different from a > > "datetime", so it seems a little weird using that sql type > > in the param > > Oh .. that. The thing to remember is cfsqltypes are based on the generic > java.sql.Types used in JDBC (for all databases). Not the names of the data > types used by your database. Obviously the two are connected, and most of > the names do correspond pretty closely. But there are a few exceptions. > "Timestamp" is one of them. > > http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html > > For whatever reason they chose not to have a type called DATETIME type, and > instead used the name TIMESTAMP. I am not sure why they chose to break with > convention there .. but they did. So "Timestamp" is the correct type to use > for date/time columns. > > (If you want some real fun, try and figure out the correct types to use for > the approximate numeric types ... ;) > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
