View Full Version : Need help: Syntax error (missing operator) in quer

12-31-2005, 09:37 PM
Hey there, can anyone suggest why I am getting the following error.
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'TimberSpeices ='.
/html/results.asp, line 68

Line 68: Command1.Execute()

I have created the following command in a results.asp page.

UPDATE tblSpecies
SET fHits = + 1
WHERE TimberSpeices = ParamSpecies

ParamSpecies Request.QueryString("TimberSpecies")

If it helps, I have a database with the following.

Table Name: tblSpecies
Column Names: idSpecies, TimberSpeices, fHits.

Also have included the code that Dreamweaver creates for the SQL.

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_connTimber_STRING
Command1.CommandText = "UPDATE tblSpecies SET fHits = + 1 WHERE TimberSpeices = " + Replace(Command1__ParamSpecies, "'", "''") + " "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true


Creative Insanity
12-31-2005, 10:08 PM
Sorry would love to help but you are using (A Silly Programming language hehe) and no I nothing about it.

01-03-2006, 09:44 AM
post your connection string in here

it should be like this

"Provider=Microsoft.Jet.OLEDB.4.0;Data source="C":\path\path\path\access.mdb;Persist Security info="False""