do you know how to fix this UPDATE errpr? : when this code runs, it says there is an UPDATE writing error. dose anybody knows whats the problem or how to fix it?


this is the cood:
string sql2 = "UPDATE ezuser";

            sql2 += " SET fname = '" + Request.Form["fname"]+ "'";
            sql2 += " , lname = '" + Request.Form["lname"] + "'";
            sql2 += " , fav = '" + Request.Form["fav"] + "'";
            sql2 += " , pw='" + Request.Form["pw"] + "'";
            sql2 += " , order = '" + Request.Form["order"] + "'";
            sql2 += " WHERE email = '" + Request.Form["email"] + "'";
            MyAdoHelper.DoQuery(fileName, sql2);