hi to all
I am trying to make a simple java servlet(like jsp) program which
allow user to update his profile
but I have a problem when user click on update's button
String un = req.getParameter("username");
String Fn = req.getParameter("Fname");
String Ln = req.getParameter("Lname");
String pw = req.getParameter("passwors");
String updateString = "UPDATE T1 SET Fname =" +Fn+", "Lname="+Ln+"
"WHERE username ="+un+ "";
int Upd;
Upd=theStatement.executeUpdate(updateString);
and this is problem
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'dWHERE username =sara s'.
but when I using this code
String updateString = "UPDATE T1 SET Fname ='xxx',Lname='yyy' WHERE username= 'sara s'";
it is ok and update the database
but i want to read change from user
can any one help me,,please
thanks