QofQ and dates...

[John Beynon]

should i be able to do date comparisons in a QofQ?
 
i'm using:
  <cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#,
now())#>    
 
  <!--- filter the recordset --->    
  <cfquery name="FilteredBlogArticles" dbtype="query">
   Select * from BlogArticles 
   where articledate >= #FilterDate#
   order by articledate DESC
  </cfquery>
 
and getting:
Query Of Queries syntax error.
Encountered "articledate >= {" at line 3, column 31. Incorrect conditional
expression, Expected one of [like|null|between|in|comparison] condition, 
 
returned. Also just noticed:
 

SQL         Select * from BlogArticles where articledate >= {ts
&apos;2002-09-24 15:12:35&apos;} order by articledate DESC      
Please try the following:       
 
tucked away at the bottom of the page....
 
thanks for the help,
 
jb.

* [EMAIL PROTECTED] * +44 (0)1372 367147 *  <http://www.era.co.uk/>
http://www.era.co.uk/

 


*************************************************************************
Copyright ERA Technology Ltd. 2002. (www.era.co.uk). All rights reserved. 
The information supplied in this email should be treated in confidence.
No liability whatsoever is accepted for any loss or damage 
suffered as a result of accessing this message or any attachments.



______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists