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")&"',)"

The reason this statement failed is because of the extra comma in the values. See above bolded.

Bob
http://totallyfreeads.com.au

THANK YOU VERY MUCH