Since the INNER JOINs are exactly backwards, this might be an easy fix. And this is not necessarily MySQL specific, it might be in the generic datamapper SQL adapter. ..tony..
On Fri, Sep 25, 2009 at 4:31 PM, Clifford Heath <[email protected]>wrote: > > On 26/09/2009, at 7:16 AM, Tony Mann wrote: > > MySQL is not happy with this, since the INNER JOINs are in the wrong > > order. If I change the order of the JOINs around, the query works: > > I want to frame this on my wall as a permanent reminder of why no-one > should ever use MySQL. > > If the code is bad enough to foul up something like this, how many > other gotchas lie hidden? > > Clifford Heath. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" 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/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
