is not null instead of <>
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: Tim Do [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 3:01 PM
To: CF-Talk
Subject: queries of queries help
Hello all,
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]
- queries of queries help Tim Do
- Tony Weeg