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
