> But *THIS* would work:
>
> <cfqueryparam value="#now()#"
> cfsqltype="cf_sql_timestamp">
That sounds more likely. I would have expected both what you posted and his
original code to work. ie:
> <cfqueryparam value="#createodbcdatetime(now())#"
> cfsqltype="CF_SQL_TIMESTAMP">
Granted the createodbcdatetime() is a bit redunant. But it should still work. I
thought it might be an odbc socket peculiarity.
-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:327162
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
