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 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">
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()))
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