John Beynon wrote:
> should i be able to do date comparisons in a QofQ?
Yes. But unfortunately it is impossible to use date objects directly in
"pass through" QofQ's, so you have to fake a prepared statement with
cfqueryparam or just use a string representation of a date.
In your case, you should be able to use:
<cfquery name="FilteredBlogArticles" dbtype="query">
Select * from BlogArticles
where articledate >= <cfqueryparam cfsqltype="cf_sql_date
value=""#FilterDate#">
order by articledate DESC
</cfquery>
Or:
<cfquery name="FilteredBlogArticles" dbtype="query">
Select * from BlogArticles
where articledate >= '2002-10-01'
order by articledate DESC
</cfquery>
Jochem
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
