I am using MS SQL 2014 and the database is running in 2008 compability mode. I am revising a classical ASP page.
I have a table that has 2 columns, CheckIn and CheckOut, which have the datatype of "time"
I can not get those two columns to update. I am using a recordset and the rest of the columns update in the table update just fine, but not those two.
I am extracting it from an XML document and they do have values. I have displayed them etc.
Do I have to convert and then plop it into the columns or what?
This is getting kinda ugly tonight...
set rsCC = Server.CreateObject("ADODB.Connection")
set rsDD = Server.CreateObject("ADODB.Recordset")
sqltxt = "Select * from Travel where RecId=" & vsep & vrecid & vsep
if not rsDD.BOF and not rsDD.EOF then
rsDD("NbrOfDays") = vnbrnights
rsDD("TotalDays") = vnbrnights
rsDD("CheckIn") = wrkstarttime
rsDD("CheckOut") = wrkendtime
set rsDD = nothing
set rsCC = nothing