I'm trying to do QofQ's and not having luck with date comparisons... here
is what I have:
<cfquery name="getIncident" dbtype="query">
select count(*) as incidentCount
from Get_Claims
where incidentOnly = 1 and dateReported <> null and dateReported between
<cfqueryparam value = "#startDate#" CFSQLType = "CF_SQL_DATE"> and
<cfqueryparam value = "#endDate#" CFSQLType = "CF_SQL_DATE">
</cfquery>
Getting this error:
Query Of Queries syntax error.
Encountered "dateReported <> null" at line 0, column 0. Incorrect
conditional _expression_, Expected one of [like|null|between|in|comparison]
condition,
Thanks,
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
