Page 1 of 1

data type error in expression

Posted: Tue 18 Apr 2006 06:40
by m3thod
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

Posted: Tue 18 Apr 2006 10:11
by Serious
Please post here in the forum a piece of your code where the error occurs.

Posted: Tue 18 Apr 2006 13:25
by m3thod
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

Posted: Wed 19 Apr 2006 06:28
by Alexey
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.