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]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
