Results 1 to 16 of 16
Thread: problem in update statement
Dec 8, 2010, 04:33 #1
- Join Date
- Jun 2010
- 1 Post(s)
- 0 Thread(s)
problem in update statement
can any1 tell me what is the problem with the following sql? it worked fine when i used the access driver connection string but after changing to the JET SQL driver it stopped working...
DB= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=path/DB.mdb; Persist Security Info=False" Set conn = Server.CreateObject("ADODB.Connection") conn.Open DB id = request.querystring("update") password = Request.Form("password") ssql = "UPDATE table SET pass='" & password & "' WHERE id=" & id conn.execute (ssql)Code:
Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement.