Hi, 1st post, please excuse any rule breaking. I've been trying to update a table thru ASP, and tried many diffrent ways to update the fields. Here's the code, the variables are passed from a form, this page is the 'form action'.
strSQL = "select * from helpdesk where SupportID = 'txtSupportID'"
Set RS = dbConn.Execute(strSQL)
SQLStmt = "UPDATE helpdesk SET progress = 'txtProgress' where SupportID = 'LogNo'"
I've also put in a couple of document.write statements containing the above txtVariables,
to check that they're being passed, which they are.
I don't get any error messages, and don't get any table updates either!