Hi Pete: Have you tried cf_sql_timestamp as the cfsqltype (as opposed to cf_sql_time)? -- Charlie Griefer http://charlie.griefer.com
I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. On Saturday, February 26, 2011 at 2:33 PM, Pete Ruckelshaus wrote: > > 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:342600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm