Problem with Using Numbers in SELECT Statement

[writhe]

I'm trying to query the database for a match in a column that contains numbers. When I try one number, like this:

"SELECT * FROM authors WHERE AuthorID = " & intNumber1

everything is fine. However, when I try this:

"SELECT * FROM authors WHERE AuthorID = " & intNumber1 & " OR " & intNumber2

all records are returned. The field I am looking through is a number/primary key field. Why is my SELECT returning everything?

I'm using Access DB on ASP platform.

[DR_LaRRY_PEpPeR]

well you're making the query be

WHERE AuthorID=2 OR 3

since 3 is non-zero, it's always a true WHERE clause. i think you want it to be this

WHERE AuthorID=2 OR AuthorID=3

i don't know about Access, but i'm sure you could use IN() instead:

WHERE AuthorID IN(2, 3)

[writhe]

Dr. Larry-

I just discovered my idiocy a few minutes ago. Sorry for such a silly post.

AuthorID =

must be used every time.