Just to clarify the way getContentObjects handles dates: - a null value in a date column will pass gt, gte, lt, lte but not eq - the dates that FarCry has used as null date substitutes at various times are also treated this way: 1 January 2050 and dates more than 100 years in the future are the same as no-date - the isnull comparison also handles the null date substitutes
Blair On Fri, Jul 16, 2010 at 11:48 AM, Phillip R <[email protected]>wrote: > I'm always cautious about placing anything on this group. I should > really measure twice before posting one. > I just realised I didn't push the latest cms plugin to the server. > Thanks Blair, for the confirming what many have suspected. (my sieve > like brain :)) > > On Jul 16, 11:30 am, Blair McKenzie <[email protected]> wrote: > > It should be doing that already. If it isn't, there's a bug. > > > > Blair > > > > On Fri, Jul 16, 2010 at 9:21 AM, Phillip R <[email protected] > >wrote: > > > > > Is there a way of have the 'OR' statement so you can get news items > > > that have no expiryDate: > > > > > <cfset q=application.fapi.getContentObjects(typename="dmNews", > > > publishdate_lte=now(), expirydate_gte=now(), orderby="publishdate > > > DESC")> > > > > > Verses the old code I've had to revert to: > > > > > <cfquery datasource="#arguments.dsn#" name="q" > > > maxrows="#maximumRows#"> > > > SELECT objectid > > > FROM #application.dbowner#dmNews > > > WHERE status IN > > > ('#ListChangeDelims(request.mode.lValidStatus,"','",",")#') > > > AND publishdate <= #now()# > > > AND (expirydate >= #now()# OR expirydate is NULL) > > > ORDER BY publishDate DESC > > > </cfquery> > > > > > -- > > > You received this message cos you are subscribed to "farcry-dev" Google > > > group. > > > To post, email: [email protected] > > > To unsubscribe, email: > > > [email protected]<farcry-dev%[email protected]> > <farcry-dev%[email protected]<farcry-dev%[email protected]> > > > > > For more options:http://groups.google.com/group/farcry-dev > > > -------------------------------- > > > Follow us on Twitter:http://twitter.com/farcry > > > > > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: > [email protected]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
