> 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:333770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
