I'm trying to query the database for a match in a column that contains numbers. When I try one number, like this:
everything is fine. However, when I try this:Code:"SELECT * FROM authors WHERE AuthorID = " & intNumber1
all records are returned. The field I am looking through is a number/primary key field. Why is my SELECT returning everything?Code:"SELECT * FROM authors WHERE AuthorID = " & intNumber1 & " OR " & intNumber2
I'm using Access DB on ASP platform.