#7 MySQLSelectCommand with join

closed
nobody
None
5
2003-12-05
2003-02-13
No

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

Discussion

  • 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.

     
  • Manuel Lucas Viñas Livschitz

    • status: open --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks