I'm all fixed on this one (Thread QofQ and dates....(FIXED))- using CFQUERYPARAM on the date fixes the problem
Thanks all! Jb. -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 16:34 To: CF-Talk Subject: Re: QofQ and dates... 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/ ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
