VS 2005 Using sqldatasource queries with "where" clause

VS 2005 Using sqldatasource queries with "where" clause

Postby TillmanZ » Mon 15 May 2006 03:43

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?
TillmanZ
 
Posts: 19
Joined: Sat 13 May 2006 04:11

Postby Alexey » Mon 15 May 2006 07:58

You should remove brackets manually.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL