Maybe. I removed the Order, put all my date calculations in the original query, and I'm on to other headaches.
Thanks for the help, you guys are legend. Chad Who has been looking for a reason to use "Legend" in a sentence. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Seano Sent: Thursday, 17 March 2005 4:02 PM To: CFAussie Mailing List Subject: [cfaussie] Re: SQL Syntax Comparing Dates Chad Need "ReturnTaskOrder" in the SELECT to be able to order it? Stab in the dark... Sean "Chad" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Any idea why this query of query: > > SELECT ProjectTaskID, Task, SchedStartDate, SchedEndDate, > ActualStartDate, ActualEndDate FROM MyProjectList > GROUP BY ProjectTaskID, ReturnTaskOrder, Task, ParentTaskID, > ProjectPhaseID, SchedStartDate, SchedEndDate, ActualStartDate, > ActualEndDate > HAVING Year(SchedStartDate) = Year(#ThisSquaresDate2#) AND > Month(SchedStartDate) = Month(#ThisSquaresDate2#) AND > Day(SchedStartDate) = Day(#ThisSquaresDate2#) > ORDER BY ParentTaskID, ReturnTaskOrder > > would result in this error: > > unknown exception condition > > PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Scott > Thornton > Sent: Thursday, 17 March 2005 1:43 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: SQL Syntax Comparing Dates > > > Two ways > > WHERE > Year(Date1 ) = year(getdate()) and > Month(Date1) = Month(getdate()) and > day(Date1) = day(getdate()) > > or my lazy method > > set dateformat dmy > select > * > from > x > where > date1=convert(datetime, convert(varchar, getdate(), 103)) > > Scott Thornton, Programmer > Application Development > Information Services and Telecommunications > Hunter-New England Area Health Service > Phone RNH +61 2 49236078 JHH +61 2 49214193 > Fax +61 2 49214191 > > [EMAIL PROTECTED] > > >>> [EMAIL PROTECTED] 17/03/2005 12:55:37 pm >>> > Say I have a 2 dates in my SQL 2K database like: 2005-03-14 00:00:00 > and 2005-03-13 00:00:00 > > What would my Where statement look like if I were to grab all records > WHERE Date1 = TodaysDate OR Date 2 = TodaysDate? > > Thanks guys! > > Chad > Who doesn't take enough time telling folk how much he appreciates > them. > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To > unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
