i got this error may i know whats wrong??
INSERT INTO Login (Staffid,Staffpass,department,designation,room,telephone,handphone,email) VALUES ('fgf','fg','Business','Technician','fg','fg','fgf','g',) Syntax error in INSERT INTO statement.No update permissionS!
The code
sql="INSERT INTO Login (Staffid,Staffpass,department,designation,room,telephone,handphone,email)"
sql=sql & " VALUES "
sql=sql &"('" & Request.Form("staffvalue")&"',"
sql=sql &"'" & Request.Form("passwdvalue")&"',"
sql=sql &"'" & Request.Form("deptvalue") &"',"
sql=sql &"'" & Request.Form("designationvalue") &"',"
sql=sql &"'" & Request.Form("roomvalue")&"',"
sql=sql &"'" & Request.Form("telvalue")&"',"
sql=sql &"'" & Request.Form("hpvalue")&"',"
sql=sql &"'" & Request.Form("emailvalue")&"',)"
INSERT INTO Login (Staffid,Staffpass,department,designation,room,telephone,handphone,email) VALUES ('fgf','fg','Business','Technician','fg','fg','fgf','g',) Syntax error in INSERT INTO statement.No update permissionS!
The code
sql="INSERT INTO Login (Staffid,Staffpass,department,designation,room,telephone,handphone,email)"
sql=sql & " VALUES "
sql=sql &"('" & Request.Form("staffvalue")&"',"
sql=sql &"'" & Request.Form("passwdvalue")&"',"
sql=sql &"'" & Request.Form("deptvalue") &"',"
sql=sql &"'" & Request.Form("designationvalue") &"',"
sql=sql &"'" & Request.Form("roomvalue")&"',"
sql=sql &"'" & Request.Form("telvalue")&"',"
sql=sql &"'" & Request.Form("hpvalue")&"',"
sql=sql &"'" & Request.Form("emailvalue")&"',)"