'BlogsPost.publish_at' => " > -!SYS_DATE" gives a query of
(BlogsPost.publish_at = ' > -!SYS_DATE') So it doesn't appear to be working. Anyone know how to see the field data type? On Jan 23, 5:57 am, "WebSpin.Biz" <[EMAIL PROTECTED]> wrote: > Try > > 'Post.added' => " > -!CURRENT_DATE" > > or > > 'Post.added' => " > -!SYS_DATE" > > The "-!" symbol tells cake 1.2 to not try to parse the oracle function > in the condition as a string. > > Raphael Spindellhttp://www.webspin.biz > > On Jan 22, 10:45 pm, Chris <[EMAIL PROTECTED]> wrote: > > > I am using CakePHP 1.2 and Oracle. > > > I am trying to figure out how to tell the find function in a > > controller that a field in the condition statement is something other > > than a string. > > > I am trying to do a comparison on a datetime field in the Oracle db. > > > so I have: > > > <code> > > $this->ControllerName->findAll( > > array( > > 'Post.added' => ' > ' . date('m/d/Y H:i:s') > > ) > > ); > > </code> > > > However, I don't want it to do the comparison against this format, I > > want it to use the Oracle format. Of course I could just format this > > in the correct format, but lets say that I can't. > > > I'm sure there is an easy way to do this. I looked in the > > dbo_oracle.php and see a function value() and see a date type in > > there, but can't figure out how to set that. > > > Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---