jmurrayhead
Programmer
This is my SQL:
Information is sent to this via a form, where all form fields listed above That have an R, (eg RStaff) are radio buttons. There is a True and False button for each name.
I get this error:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/updacc.asp, line 13
Line 13 is the above SQL statement.
Any ideas? Thanks
Code:
Set rs = Conn.Execute("UPDATE Users SET Webmaster = '" & request.form("RWebmaster") & "' AND Teachers = '" & request.form("RTeachers") & "' AND Staff = '" & request.form("RStaff") & "' AND Parents = '" & request.form("RParents") & "' AND Students = '" & request.form("RStudents") & "' WHERE UserName = '" & request.form("Users") & "'")
Information is sent to this via a form, where all form fields listed above That have an R, (eg RStaff) are radio buttons. There is a True and False button for each name.
I get this error:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/updacc.asp, line 13
Line 13 is the above SQL statement.
Any ideas? Thanks