asp to access database

[dcarbone]

I am trying to select records from a table, based on their number in an autonumber field. But when i run the query, i get DATA type mismatch.

i used the following code

sql = "select * from table where ID = '"& id &"' "

 

[SarkMan]

Remove the single quotes around the id
since the field should be a number

sql = "select * from table where ID = "& id

 

[alsoknownas]

what id number are you trying to display?

Replace the '"& id &"' " with the id number you're trying to display

--------------------------------------------------------------------------------------------

 

[alsoknownas]

I guess you're not trying to display a specific Id. do as SarkMan said

--------------------------------------------------------------------------------------------