data type error in expression

data type error in expression

Postby 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
m3thod
 
Posts: 2
Joined: Tue 18 Apr 2006 06:29

Postby Serious » Tue 18 Apr 2006 10:11

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

Postby 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
m3thod
 
Posts: 2
Joined: Tue 18 Apr 2006 06:29

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL