ok penso d'aver capito... però non riesco a fare l'update del record:la query restituisce:codice:If NOT session("login") then response.redirect "/it/dx_old.asp" else 'vendemmia la form mailbox = Request.Form("mailbox") pwd = Request.Form("pwd") email = Request.Form("email") id = session("id") 'leggi db Set objConn = Server.CreateObject("ADODB.Connection") strConn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("/database.mdb") objConn.Open strConn strsql = "SELECT account FROM tbl_login WHERE account = '" &request("mailbox")& "' " Set objRs = Server.CreateObject("ADODB.Recordset") objRs.Open strsql, strConn, 3, 3 'user esistente if not objRs.bof and not objRs.eof then Response.write "'user esistente " else sql = "UPDATE tbl_login SET account = '" &request("mailbox")& "' and psw = '" &request("pwd")& "' WHERE id = " & session("id") objConn.execute(sql)dove sbaglio?UPDATE tbl_login SET account = '' and psw = '' WHERE id = 121

Rispondi quotando