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]> > > 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
