>>>>
>>>>BTW, did you try in MySQL directly
>>>>
>>>>
select * from MyTable where myField like '%t%'
?
>>>
>>>Yes, of course. And of course it works.
>>>
>>>The problem is that MySql seems to be getting
>>>select * from myTable where myField LIKE '% '+ 't' + '%')' at line 1
>>
>>Ok, I understood it and already suggested a workaround. Use select * from myTable where myField like ? and set your parameter in the Selecting event.
>
>Sorry about being so dense but what code should I use to set the parameter in the Selecting event?
e.Command.Parameters('Resource').Value = '%' + txtCustomer.Text + '%'
If it's not broken, fix it until it is.
My Blog