Hi, bit of a noob so this could well be my problem (isn't it always ;)
I'm doing a little date comparison such as you suggested > 2) > $conditions['Post.created'] = 'BETWEEN 2007-02-01 AND 2007-02-28'; > (iirc) but not getting any results. So I dumped out the contents of the cake generated SQL and it's escaping the 'BETWEEN' as: "(`Post`.`created` = ' BETWEEN 2007-2-01' AND ' 2007-03-01') Am I doing anything wrong? it looks like the SQL generator in cake is not "seeing" BETWEEN as a reserved word? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
