Hy all:
Few days ago, i change my default.asp to get a table with the top posters and the last post. All was ok and suddenly after 5 days without problems i get this error trying to access
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'CDate'
/forum/common.asp, line 448
My hosting service told me they didn't make changes in the host. And i only change to version 7.9 and the default.asp. I put the old one (a backup) and the problem continue.
The code of the line is this (in common.asp):
'Read in the Last Visit Date for the user from the db if we haven't already
If Session("ViRead") = "" Then
If isDate(rsCommon("Last_visit")) Then Session("dtmLastVisit") = CDate(rsCommon("Last_visit"))
Session("ViRead") = True
End If
'Check that there is a last visit date in the db or we will get an error
If isDate(rsCommon("Last_visit")) Then
'If the Last Visit date in the db is older than 5 minutes for the user then update it
If CDate(rsCommon("Last_visit")) < DateAdd("n", -5, Now()) Then
'Initilse sql statement
If strDatabaseType = "SQLServer" Then
strSQL = "EXECUTE " & strDbProc & "UpdateLasVisit @lngUserID = " & lngLoggedInUserID
Else
strSQL = "UPDATE " & strDbTable & "Author SET " & strDbTable & "Author.Last_visit = Now() WHERE " & strDbTable & "Author.Author_ID=" & lngLoggedInUserID & ";"
End If
'Write to database
adoCon.Execute(strSQL)
End If
Please i need some help.
Thank u