#7 MySQLSelectCommand with join

[Xavier Méhaut]

Hello,
It seems that the following expression can't be treated :
new MySQLDriverCS.MySQLSelectCommand
(myConnection, new string[]
{"Name","Version"}, new string[]
{"project_deliveries", "product_deliveries"}, new object[,]
{{"product_deliveries.ProductVersion" ,"=",
selectedProductVersion},
{"project_deliveries.ProjectId", "=" , "product_deliveries.Proj
ectId"}}, null, null)
The join
{"project_deliveries.ProjectId", "=" , "product_deliveries.Proj
ectId"} is not allowed...
regards
Xavier

[Nobody/Anonymous]

Logged In: NO

I've also noticed that in the WHERE section, you cannot do a:

new object(,) {{ "empPassword", "=", "PASSWORD('" &
txtpassword.text.tostring & "')" }}

[Manuel Lucas Viñas Livschitz]

Logged In: YES
user_id=406263

Well the join error can be avoided using aliases. On the other
hand the 'PASSWORD' expresion as other expresions must be
put in other part of the where section, the part marked for
expressions.