liewsin Posted February 6, 2006 Share Posted February 6, 2006 hican anyone tell me, is it the IN operator can't be use/not supported in MS Access database?SELECT * FROM CustomersWHERE UserID IN ('1004','1005','1006')[Result]Data type mismatch in criteria expressionBTW, i am using ColdFusion and MS Access DB together. Link to comment Share on other sites More sharing options...
aspnetguy Posted February 6, 2006 Share Posted February 6, 2006 I just ran the following query on my Access DB with no problems SELECT *FROM RelatedPagesWHERE Label IN ('IBM','Spatter'); Is UserID a number or is it of the type text??If it is a number then try this SELECT * FROM CustomersWHERE UserID IN (1004,1005,1006) Link to comment Share on other sites More sharing options...
liewsin Posted February 6, 2006 Author Share Posted February 6, 2006 Thx mate! it works! LOL I just ran the following query on my Access DB with no problemsSELECT *FROM RelatedPagesWHERE Label IN ('IBM','Spatter'); Is UserID a number or is it of the type text??If it is a number then try this SELECT * FROM CustomersWHERE UserID IN (1004,1005,1006) <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
aspnetguy Posted February 6, 2006 Share Posted February 6, 2006 no problem, glad i could help Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now