inserting values error

gtmm9 · October 6th, 2003, 11:32 AM

I am getting the following error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement.

I am trying to insert values into a database. the user submits a form for user id and password and the code enters the password for matching user id
mySQL = "insert into password1 (password) values"
   mySQL = mySQL& "('" & password & "')"
   mySQL = mySQL& " where uid = '" & uid & "'"

   Set objRS2 = objConn.Execute (mySQL)

Please help

jacob · October 6th, 2003, 11:43 AM

The error message says that you are missing a semicolon at the end of the statement, right? So try this...

Code:

mySQL = "insert into password1 (password) values"
mySQL = mySQL& "('" & password & "')"
mySQL = mySQL&  " where uid = '" & uid & "';"

Perhaps...!?

Hope it helps

Jacob.