JET Database Engine error 80040e14

[LaPluma]

Hello

I am getting the following error message:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'ThreadID= AND ThreadP=0'.

/db/planet/repost.asp, line 17

which is located here:

http://www11.brinkster.com/stevehigham/db/planet/repost.asp

The message seems to refer to the following SQL statement in the repost.asp file:

rsget.Open "SELECT * FROM board WHERE ThreadID=" & id & " AND ThreadP=0", conn

Thread and ThreadP are numeric fields in the MS Access 2000 database I am using.

What does the error 'Missing Operator' mean, please? I have tried removing quotes in the SQL statement, and adding single quotes to it, but I continue to get error messages.

Thanks for any help.

LaPluma

 

[snowboardr]

Syntax error (missing operator) in query expression 'ThreadID= AND ThreadP=0'.

there is no value for ThreadID and also Im guessing ThreadP is incorrect as well, because autonumber don't start at 0 they start at 1

When its numeric you don't put single quotes around it. www.vzio.com

/

 

[LaPluma]

Hello Snowboard

Thank you for your message.

I am still getting the following message (I have changed the 0 to 1).

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'ThreadID= AND ThreadP=1'.

/stevehigham/db/planet/repost.asp, line 17

Any other assistance would be appreciated.

Many thanks

 

[snowboardr]

Syntax error (missing operator) in query expression 'ThreadID= AND ThreadP=1'.

You still don't have a value for threadID this is what is causing the error now. www.vzio.com

/