Simple Help For Select Statement in ASP

Select Statement in ASP

[Dolphins39]

Whenever i run this script, it says i have a data type mismatch, which is because i need the data to be a number, but i don't know how to do that. ID is a variable. and entry ID is autonumber. Thanks

set RS=Conn.execute ("Select * From Table WHERE entryID='" & ID & "'")

[macrost]

set RS=Conn.execute ("Select * From Table WHERE entryID = " & ID)

No single quotes are needed if you only need an integer.
Mac

[Dolphins39]

Thanks

Works Perfect