ODBC Error 80040e10 - can’t find the prob

Hi,

I have a db driven page and am getting the following error: 

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

The area of code in question reads:

<%

set cmdMsg = Server.CreateObject("ADODB.Command")
cmdMsg.ActiveConnection = MM_cnTOforum_STRING
cmdMsg.CommandText = "UPDATE MESSAGES  SET MSG_READ_COUNT  = MSG_READ_COUNT + 1  WHERE MSG_ID = varID "
cmdMsg.CommandType = 1
cmdMsg.CommandTimeout = 0
cmdMsg.Prepared = true
cmdMsg.Execute()

%>

I know this error pertains to a missing or mistyped field name in the db, but everything is typed correctly.

Help!

i assume "varID" is some sort of variable in ASP... if it is, your syntax is all wrong

cmdMsg.CommandText = "UPDATE MESSAGES SET MSG_READ_COUNT = MSG_READ_COUNT + 1 WHERE MSG_ID = " & varID

Thank you so much for the help, I'm a newbie at this.

I made the &varID change, now I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'MSG_ID ='.

 

why do you think that?

you need to answer that question first... because you could go back and forth all day with people on the forums trying to teach you that you are trying to build a SQL string, and having varID in quotes tells ASP to take that literally, not "replace with the value of the variable"

and if you don't have that variable assigned anywhere, you are going to through that error.....