On Sat, 2009-08-08 at 19:56 -0400, Drew Jensen wrote:
> > Interesting....
> >
> > So it matters what order the "ands" and "ors" are in?
> >
> > Keith
> >
>
> Well the GUI designer trys to put ANDs before ORs..that I've seen before.
> However - I just ran all this with an earlier 3.1.1 development build
> and not the 3.1.1 RC1 build.
> I will be installing the RC1 package later tonight and will see if
> anything changes .
Actually Drew, I just flipped it and I still get a Query Too Complex
SELECT `Date`, weekday( `Date` ) AS `Weekday`,
`Precipitation` AS `Precip`
FROM `kwbo4418_WaterlooWeather2000`.`2005` AS `2005`
WHERE `Precipitation` > 0
AND ( weekday( `Date` ) = 4
OR weekday( `Date` ) = 5
OR weekday( `Date` ) = 6 )
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
