Here's the error below that I'm getting. I'm initially querying a view and then requerying it to get certain counts. Any suggestions?
Query Of Queries runtime error.
Comparison Exception: While executing ">="
Unsupported Type Comparison Exception: Comparator operator ">=" does not support comparison between following types:
Left hand side expression type = "TIMESTAMP".
Right hand side expression type = "LONG".
The error occurred in C:\CFusionMX7\wwwroot\WData\Jobs\Selects\Reports\Recency_Report.cfm: line 121
119 : Select Count(*) As DonorCount
120 : From RecencyValues
121 : Where (HPC < 5) and (DaysOut >= #DayValues[OuterLoop]#) and (DaysOut <= #DayValues[OuterLoop]#)
122 : </cfquery>