2 Replies Latest reply on May 3, 2008 12:05 AM by Gregory Lafrance

    Passing a Date from DateChooser

    kdennis4
      I have this query listed below:

      Select CONVERT(datetime, (STR(DATEPART(mm,projectStart)) + '/' + STR(DATEPART(dd,projectStart)) + '/' +
      STR(DATEPART(yyyy,projectStart)))) AS projectStart,
      CONVERT(datetime, (STR(DATEPART(mm,projectEnd)) + '/' + STR(DATEPART(dd,projectEnd)) + '/' +
      STR(DATEPART(yyyy,projectEnd)))) AS projectEnd
      From creativeAssignTimeStatus
      Where projectDesigner = '#thisDesignerName#'
      and projectAssigned = '#thisSelectedProject#'
      and projectStart = '#thisSelectedDate#'
      and projectEnd = '#thisSelectedDate#'

      I placed this to test it:

      <cfif getAllRelatedHours.Recordcount GTE 1>
      <cfthrow message="working">
      </cfif>

      Anyone have an idea of what I'm doing wrong in my code? Thanks in advance for the help!