VS 2005 Using sqldatasource queries with "where" clause

[TillmanZ]

Hi!

I want to use an sqldatasource with a select statement like this:

select a, b, c from table where d = Profile.custominfo;

VS 2005 puts it like this:

select a, b, c from table where d = ([custominfo] = ?);

and then it adds:




Unfortunately that does not work with the mysql connector.

Any ideas?

[Alexey]

You should remove brackets manually.