Are you using a cfqueryparam cfsqltype="CF_SQL_TIME"? That might take care of it when inserting?
....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com "You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills." - Napoleon Dynamite -----Original Message----- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Thursday, June 01, 2006 4:52 PM To: CF-Talk Subject: Help w/ Invalid time format. All, I have a serices of strings coming back from a web service that I need to parse i.e. Time = "4:00pm" that I need to parse to append to a date to insert into a SQL Server database in a datetime field. How can I get this into the correct format to insert into the table? CF MX7 Error "4:00pm" is an invalid time format. Thanks in advance! -Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241979 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
