Updating fields mysql

How do i make this so it will add/update records for My SQL, also i dont know if i did something or what but the i use to be able to get a list of sub commands from the recordset Ex. Fields or krs2.update now i have to type manual how can i get this to pop back up and work as well? Recordset error '800a0cb3' Current Recordset does not support updating.This may be a limitation of the provider, or of the selected locktype.sub Insert Failed Login dim strcon2,sqltemp2, myname, mypassword Session("Logged In") = "no" myname=request.form("txt Us jitganguly i get this error ADODB.Connection error '800a0e78' Operation is not allowed when the object is closed.and i had to make a change because it wanted username/password after the strcon2 ado Con2.Open str Con2,,,ad Open Dynamic t") rstemp2sqltemp,conntemp2,3,3 call getbrowser rstemp2.addnew rstemp2("Session ID") = session.

Fields("password")=myasp" krs3.close adocon3.close set krs3=nothing set adocon3=nothing else 'Invalid Password krs3.close adocon3.close set krs3=nothing set adocon3=nothing call Insert Failed Login Session("Message") = "Invalid password.Please, try again." response.redirect "Login.asp" end if end sub '=========================) If then krs.close adocon.close set krs=nothing set adocon=nothing Session("Message") = "Invalid username.Please, try again." response.redirect "Login.asp" end if 'If password is correct run code If krs.Fields("password")=mypasp" krs.close adocon.close set krs=nothing set adocon=nothing else 'Invalid Password krs.close adocon.close set krs=nothing set adocon=nothing call Insert Failed Login Session("Message") = "Invalid password.Please, try again." response.redirect "Login.asp" end if end sub % i took that sub out i forgot to remove it and it still doesnt work.See all of it use to be coded for access and i switched to mysql so it is probelly a little sloppy.

You must have an account to comment. Please register or login here!