data type error in expression

m3thod · Post by **m3thod** » Tue 18 Apr 2006 06:40

i get this error "data type error in expression" when using @Field param to filter a table from the query builder
i use the latest mysqldirect.net
10x for your help

Serious · Post by **Serious** » Tue 18 Apr 2006 10:11

Please post here in the forum a piece of your code where the error occurs.

m3thod · Post by **m3thod** » Tue 18 Apr 2006 13:25

this is the query
it works just fine on sqlexpress 2005

SELECT * FROM tipdata WHERE (fielda=@fielda)

i need it to pass the param via a control, a dropdownlist

Alexey · Post by **Alexey** » Wed 19 Apr 2006 06:28

Please specify the problem. Where do you write this query? When is it being executed? Provide us with the code snippet which includes invoking of this statement.