timcadieux
Programmer
I'm using th ebelow code to add to my DB then i want it to go back to my main page. It does add the info, but it just site on "Category Addded". I'm using the exact same code for my DELETE AND EDIT Functions and they work fine?
Code:
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM Categories WHERE CategoriesID=0;"
rs.Open strSQL, Application("Connection1_ConnectionString") , adOpenKeyset, adLockPessimistic, adCmdText
'Add a record to the Category Table
rs.AddNew
rs.Fields("Category").Value = request.form("category")
rs.Update
rs.Close
Set rs = Nothing
response.Write("Category Added")
response.Redirect("0_6_1_0.asp")
'Server.Execute("0_6_1_0.asp")