> I found the problem (or at least a workaround). I changed > the cfsqltype to be a timestamp instead of a datetime and that > did the trick. Seems a little odd, but at this > point, whatever works.
There is no cfsqltype named "cf_sql_datetime". So CF may be using the default instead cf_sql_char. Anyway, you are correct in selecting cf_sql_timestamp. That is the right type for MS SQL date/time columns. -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
