This is an Error here...but I can't find it

[mlocurci]

There is an error here. But i am missing it. Any ideas by you smart guys?

mysql="UPDATE tbleTimeOffrequests SET "
mysql=mysql & "HRstatus='" & Request.Form("hrStatus&quot &"',"
mysql=mysql & " Where ID=" & Request.Form("id&quot

 

[GaryC123]

take the comma out -
("hrStatus&quot &"', "
make so -
("hrStatus&quot &"' "

Saturday 12.00

20.00

3.00am

Sunday [img http

 

[snowboardr]

With every sql statement you should Response.Write mysql below your statement, if there is an error, you will easily be able to pin-point it. You will then be able to catch almost ever SQL related error.

- Jason www.vzio.com
ASP WEB DEVELOPMENT