could you please post the criteria you used ?
jakob
Hinnerk Feldwisch wrote:
Hello,
after "hours" of debugging I found the problem with my m:n- mapping: the cause of it was that I used the same name for the collection- name and the (mysql- ) table.... very annoying, I should name all tables like "table_friends" now! :/
But perhabs the SQL- code which is generated by SqlGeneratorDefaultImpl could be made more robust? It would be nice to know that I'm the only one who had to find the sollution for this problem :)
Here is the crazy but "faulty" code: SELECT A0.password,A0.nickname,A0.gbId,A0.imageFileName, (...) FROM USERS A0,friends INNER JOIN friends A1 ON A0.userId=A1.theUserId INNER JOIN USERS A2 ON A1.friendId=A2.userId WHERE (A1.theUserId = 163 ) AND friendId = A0.userId
And it should be: SELECT A0.password,A0.nickname,A0.gbId,A0.imageFileName, (...) FROM USERS A0,friends A1 WHERE (A1.theUserId = 163 ) AND A1.friendId = A0.userId
Thank you though for all your good work!, Hinnerk
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
