i want to update my record but theres an error....

Syntax error in UPDATE statement. line 11. the code is

<%

MsgNo=request.querystring("MsgNo")

set con = server.createobject("ADODB.Connection")
scon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".././dbase/thesis.mdb") & ";"
con.open scon
a= Trim(request("passcode"))

sql= "update tblOJTStud set Password= '"&a&"' where StudID="&StudID
con.execute(sql)

Response.redirect "adminOJTshowStudmain.asp?sortby=StudID"

con.close
set con=Nothing
%>

Can somebody help me with this?? Any help is more than appreciated! :-)

how are you getting/setting the value for StudID? It doesn't appear in the posted code....

Other problems could be in the content of the password.

Before your con.execute line add in Response.Write(sql) and post the resulting line here.

it looks like you are not actually retrieving a value for a
"a= Trim(request("passcode"))"

"request" what ?
also.. is StudID a string or a number defined in the database ?
if its a string field then that will blow up in your update

if you use request without specifying form or querystring it will try both....

I'm not sure what order it tries in (form then querystring or querystring then form) however.

It can be helpful at times...

wow.
never knew that.

Yeah, it was a few years of developing asp apps before I knew about it either. There are not many places I would use it as it tends to be less efficient then a request.form or request.querystring but it does allow extra flexibility so...