what wrong with the following code, as I can't find any error and the syntax seem true
note:
every variable in session are string type
Code:
dim cn as new oledbconnection(application("cnStr"))
dim sql as string="update users set bgcolor=@bgcolor,fontcolor=@fontcolor,visited=@visited,alink=@alink where login_id=@login_id"
dim cmd as new oledbcommand(sql,cn)
cmd.parameters.add(new oledbparameter("@bgcolor",oledbtype.char,10))
cmd.parameters("@bgcolor").value=session("bgcolor")
cmd.parameters.add(new oledbparameter("@fontcolor",oledbtype.char,10))
cmd.parameters("@fontcolor").value=session("fontcolor")
cmd.parameters.add(new oledbparameter("@visited",oledbtype.char,10))
cmd.parameters("@visited").value=session("visited")
cmd.parameters.add(new oledbparameter("@alink",oledbtype.char,10))
cmd.parameters("@alink").value=session("alink")
cmd.parameters.add(new oledbparameter("@login_id",oledbtype.char,19))
cmd.parameters("@login_id").value=session("userid")
try
cn.open()
cmd=new oledbcommand(sql,cn)
cmd.executeNonQuery()
catch ex as exception
response.write(ex.toString())
Finally
cn.dispose()
session.abandon
end try
System.Data.OleDb.OleDbException: No value given for one or more required parameters. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at ASP.Logout_aspx.page_load(Object sender, EventArgs e) in D:\IP2\logout.aspx:line 48
For question asking, please made sure that your question is as similar as possible while providing enought level of details!
Since not all peoples, like to read large amounts of text just for reading or requirement and waste the answer time to read your text
OIeDbCommand and Session Question
