troubleshooting Question

CFQuery Help...

Avatar of Lee R Liddick Jr
Lee R Liddick JrFlag for United States of America asked on
Web Servers
2 Comments1 Solution261 ViewsLast Modified:
I have no idea what is wrong with this...it was working yesterday and this morning and I don't remember making any changes to any of my queries this morning.  The only thing I did was change some background colors on some of the pages but I can't imagine that did anything.  But it doesn't matter what I do, this query doesn't work any more and I get the error "Invalid parameter 1 specified for dateadd."

What is wrong with this query??????
 
<cfquery datasource="mydatasource" name="getMyCompletedCases">
SELECT MAN.intcaseID,
      MAN.strRequester,
      MAN.strCaseType,
      MAN.strCaseProd,
      MAN.strCaseCat,
      MAN.strCaseCatItem,
      MDT.strCaseDetail,
      STA.strCaseStatName,
      SEV.strCaseSevName,
      MDA.dtiCaseOpen,
      MDA.dtiCaseComplete,
      MAN.dtiDateRequired,
      MST.intID,
      MST.intCaseStatID,
      MST.dtiModified,
      MST.active
FROM tbl_casemain MAN LEFT JOIN tbl_caseseverity SEV ON SEV.intCaseSevID = MAN.intCaseSevID
      INNER JOIN tbl_casemaindata MDA ON MDA.intCaseID = MAN.intCaseID
      INNER JOIN tbl_casemaindetails MDT ON MDT.intCaseID = MAN.intCaseID
      INNER JOIN tbl_casemainstatus MST ON MST.intCaseID = MAN.intCaseID
      INNER JOIN tbl_casestatus STA ON STA.intCaseStatID = MST.intCaseStatID
      INNER JOIN tbl_caseactivitytype ACT ON ACT.intCaseActTypeID = MST.intCaseActTypeID
WHERE MAN.strRequester = '#session.UserData.CUID#'
AND   MST.intID = (select max(b.IntID) from tbl_casemainstatus B
              where b.intCaseID = MST.intCaseID and
              b.dtiModified >= MST.dtiModified
         )
AND MST.intcaseStatID >= 8
AND (MDA.dtiCaseComplete BETWEEN DateAdd("d", -30, GetDate()) AND DateAdd("d", -1, GetDate()))
ORDER BY MAN.intCaseID
</cfquery>
ASKER CERTIFIED SOLUTION
Scott Bennett
Manager Technology

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros