Martin, thank you for your tips. Unfortunately upgrading to 1.2 is not an option now... I can't decide it myself... I already had done the check you suggest, now I re-done... but everythings looks right...
> The IN part is probably not the problem. It looks ok and is basically > shorthand for WHERE Donetask.order_id = 00019281 OR Donetask.order_id > = 00019280... I agree, but... ;-) The IN() part is the only difference I can see between the old and the new version. I try to explain: Running the script with debug=2 I can see that the query I mentioned above returns 21 rows that is the same result I obtain if I run the SELECT statement manually from the command line. So the query in itself is ok. What i find after some investigation is that: On 1.1.15, Cake runs a select query on Donetask for every Order item then it merges the resulting rows in the resultset array On 1.1.19, Cake runs only one query on Donetask with that WHERE .. IN() syntax. As said with debug=2 I can see that the number of resulting rows is correct, but looks like that cake can't merge the hasMany results in the resultset array I run the old and the new version on the same machine, same mysql server, even same db. Any other hint? Stefano --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
