Hey, that did it! Thanks! Pete
On Sat, Feb 26, 2011 at 4:43 PM, Charlie Griefer <[email protected]>wrote: > > 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:342601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
