Hey,

This is basically an error with your actual SQL query. You need to first make sure that the query works directly against the database, before trying to run it through your code. Do you have the MySql Tools installed, so that you can run the query in Query Browser? If not, I would highly recommend that you do this. Make sure you can run the query, and get the result you expect, before trying to run your code.

Also, this would be a good opportunity to change you MySqlCommand object to use Parameters.

I am away to sign off now, but I will try and check back in the next couple days to see how you are getting on.

As a quick clue though, I think this is going to be part of your problem:

Code:
WERE
Gary