Re: Between Join producing invalid SQL

2007-08-10 Thread dmorris
Rahul offered the following solutions, but these didn't work either - does anyone have any other suggestions? $conditions['AND']['Target.month'] = "BETWEEN \'$startMonth\' and \'$endMonth\'"; This lead to the following sql, which didn't work SELECT `Target`.`id`, `Target`.`month`, `Target`.`in

Between Join producing invalid SQL

2007-08-08 Thread dmorris
Hi All. I'm fairly new to coding in Cake and can't find any resource to help me solve this problem. I appear to be doing the same as all the code snippets I have seen, but I must be missing something. The following code $conditions['AND']['Target.month'] = "BETWEEN $startMonth and $endMonth"; $