Update Records From User Input - Any Good Samples?

Edited by SomeNewKid. Please post code between <code> and </code> tags.








Right now i'm just trying to get the page to update SQL, but its not working no errors or anything but still not updating?!?!





Any ideas? Thanks in advance





Ben





<%


Dim cnnSimple ' ADO connection


Dim rstSimple ' ADO recordset





Set cnnSimple = Server.CreateObject("ADODB.Connection")





cnnSimple.Open Blah Blah Blah





Set rstSimple = cnnSimple.Execute("SELECT * FROM WK_DATA WHERE WEEK_NUM = 2")





%>


<input name="Submit" type="button" value="Add">


<%





If Request.Form("Submit") = "Add" Then


cnnSimple.Execute("UPDATE WK_DATA SET PRICE = (PRICE + 1) WHERE WEEK_NUM = 2")


rstSimple.update


End If





cnnSimple.Close


Set cnnSimple = Nothing


%>