On Sat, 2009-08-08 at 19:24 -0400, Drew Jensen wrote: > Keith Clark wrote: > > On Sat, 2009-08-08 at 19:07 -0400, Drew Jensen wrote: > > > >> Keith Clark wrote: > >> > >>> Why is the following query too complex to be viewed in the design mode? > >>> > >>> SELECT `Date`, weekday( `Date` ) AS `Weekday`, > >>> `Precipitation` AS `Precip` > >>> FROM `kwbo4418_WaterlooWeather2000`.`2005` AS `2005` > >>> WHERE ( weekday( `Date` ) = '4' > >>> OR weekday( `Date` ) = '5' > >>> OR weekday( `Date` ) = '6' ) > >>> AND `Precipitation` > 0 > >>> > >>> > >>> > >> Without trying it - change the criteria to 4, 5 and 6 vs `4`, etc. > >> > >> > >> > > > > Hmm, still says Query Too Complex. > > > > > Are you using the Native connector? I just constructed something > similar and it takes it - but - and I didn't notice this before (how did > I miss this) it wants to use double quotes... so the SQL turns into > SELECT "Date", weekday( "Date" ), "precipt" FROM "MSIS"."precipitation" > AS "precipitation" WHERE ( "precipt" > 0 AND weekday( "Date" ) = '4' OR > weekday( "Date" ) = '5' OR weekday( "Date" ) = '6' ) > I am using the jdbc connector to a MySQL remote database
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
