RE: QofQ and dates...

[Mike Townend]

Try adding a createodcdate around it... 

<cfset FilterDate = dateadd('d', arguments.AgeArticlesOnHomePage,
now())>   
  <cfquery name="FilteredBlogArticles" dbtype="query">
   Select * from BlogArticles 
   where articledate >= #CreateODBCDate(FilterDate)#
   order by articledate DESC
  </cfquery>

HTH


 

-----Original Message-----
From: John Beynon [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, October 1, 2002 15:19
To: CF-Talk
Subject: QofQ and dates...


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.




______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
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