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/
