Re: Ado Recordset Update

steve schofield — Sat, 13 Jun 2009 08:06:18 GMT

Sounds like a change in locale on the server was make or some other machine setting, or update. I would check with the provider or server admin. It doesn't hurt to use the CDATE function, which ensures the data is actually a date. I'd leave it personally.

Ado Recordset Update

NewDev01 — Sat, 13 Jun 2009 07:12:13 GMT

Dim dbCon, sql, trandate, rsBatch, selectBatch, strconn

Set dbCon = Server.CreateObject("ADODB.Connection")
dbCon.open Session("strConn")
dbCon.BeginTrans

Set rsBatch = server.createobject("ADODB.Recordset")
rsBatch.ActiveConnection = dbCon
rsBatch.LockType = adLockOptimistic
rsBatch.CursorLocation = adUseServer
rsBatch.CursorType = adOpenKeyset
selectBatch = "SELECT TextFld, TranDate from tab1"
rsBatch.open selectBatch, dbCon
rsBatch.AddNew
rsBatch("TextFld") = "Some Text"
rsBatch("TranDate") = "06/10/2009"
rsBatch.Update

dbCon.CommitTrans
rsBatch.Close
Set rsBatch = Nothing
dbCon.Close

Hi,

The above code, till yesterday was working fine..All of a sudden, from today morning the "Trandate" field..Although i'm setting date in "06/10/2009"[mm/dd/yyyy] format..ado recordset update reformats to "10/06/2009"..but if i give CDate("06/10/2009") it works fine and take as "06/10/2009"...pls help me to sort out this..till yesterday it was working fine..it happen from today.. i checked the regional setting, nothing changed there.

pls comment

thanks

Classic ASP

Re: Ado Recordset Update

Ado Recordset Update