I don't think my code get to error;
please check the code for me
i have found but i can see where error was
this is my code UPDATE:
if trim(request("Option"))="EditCustomer" then
CustomerId = trim(request.form("CustomerId"))
strupdate="UPDATE customer SET CustomerId ='"&CustomerId&"',firstname='"&Firstname&"'"&","
strupdate=strupdate&"Lastname ='"&lastname&"',Gender='"&Gender&"'"&","
strupdate=strupdate&"email ='"&email&"',phone='"+phone+"'"&","
strupdate=strupdate&"nation ='"&nation&"',customertype ='"&customertype&"'"&","
strupdate=strupdate&"note='"¬e&"',status='"&sta tuss&"'"
strupdate=strupdate&"WHERE CustomerId ='"+request.QueryString("CustomerId")+"';"
'response.Write(strupdate)
Set rs = Conn.execute(strupdate)---(error here)
Response.Redirect("ListCustomer.asp")
rs.Close
Set rs=nothing
end if
thanks
Regards
Hoang Phuc