I have the following query:
<CFQUERY NAME="ExpiredArticles" DATASOURCE="#mylibrarydata#" username="#sqlusername#" password="#sqlpassword#">
SELECT articleid,title,articledate,requests,ahitcount FROM articles
WHERE (articles.articledate<(Now()-8)) AND articles.requests>0 AND articles.words>-1
ORDER BY articles.articledate;
Basically what I'm doing is taking today's date and comparing it to an articledate within the the query. For some reason though it's outputting all the results from the db. Any idea why this is?