I'm building an app for keeping track of high school track meet results using CF9 and MS SQL Server 2008. I am using the "time(7)" data type in the database, and when doing the insert query, I'm using <cfqueryparam> with a sqltype of cf_sql_time. However, when entering a time value of, for example, "00:01:22.05", the value that actually gets inserted drops the decimal part of the seconds. When I do the insert query without using <cfqueryparam>, it works fine. I prefer using cfqueryparam for obvious reasons and am always hesitant to not use it, so is there a way to get it to work and still have it retain the decimal portion of the second?
Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm