I used to be able to use the following code to track updates made to certain records. It no longer works with ASPRunner 3.2. Can someone please make suggestions as to what I need to change to accomplish this again. Thanks
if (Request.Form("saveid")<>"" and Request.Form("action")="edit") then
strSQL = "insert into Audit (ID,User,Updated,Type,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec) values ('"& Request.Form("saveid") &"','" & Session("UserID") & "', Now(),'"& Request.Form("Action") &"','"& Request.Form("Jan") &"','"& Request.Form("Feb") &"','"& Request.Form("Mar") &"','"& Request.Form("Apr") &"','"& Request.Form("May") &"','"& Request.Form("Jun") &"','"& Request.Form("Jul") &"','"& Request.Form("Aug") &"','"& Request.Form("Sep") &"','"& Request.Form("Oct") &"','"& Request.Form("Nov") &"','"& Request.Form("Dec") &"')"
dbConnection.Execute strSQL
end if
