I don't _think_ QofQ does date comparisons ... However... You could probably
transform the dates in the original quer(y|ies) into a separate column i.e.
convert(int,convert(varchar,Year(datecolumn)) +
convert(varchar,month(datecolumn)) + convert(varchar,day(datecolumn))) AS
date
This would give you something like
20020615 for the 15th of June 2002 ... Since the string is all numbers, it
will sort alphabetically ...
Or I'm told you can convert a date to an integer or a float value in SQL
Server? ...
convert(int,mydatecolumn)
then the QofQ could sort or filter on that integer value
hth
S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
> 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
> '2002-09-24 15:12:35'} 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/
______________________________________________________________________
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
