SQL Issue with NULL

I had a query of a query working like this: WHERE Response_DT IS NOT NULL Does that work for you? > Matthew, > > I wish that was it. But it still doesn't work I've tried this query > every way and the only time it runs is when I take NULL out of the QoQ. > > Regards, > JB > > > <CFQUERY name="CallCachedQuery" dbtype="query"> > SELECT * > FROM CreateTimedCached > WHERE NOT Response_DT IS NULL > </CFQUERY> > > Error Diagnostic Information > Query Manipulation Error Code = 0 > > Invalid Operator NOT > SQL = "SELECT * FROM CreateTimedCached WHERE NOT Response_DT IS NULL" > Data Source = "" > > Date/Time: 04/27/03 10:37:06 > Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) > Remote Address: 127.0.0.1 > > > Matthew Walker wrote: > > >>Error Executing Database Query. > >>[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > >>'CreateTimedCached'. > >>  The Error Occurred in C:\CFusionMX\wwwroot\testQ0Q.cfm: line 23 > >> 21 : FROM CreateTimedCached > >>22 : WHERE NOT Response_DT IS NULL > >>23 : </CFQUERY> > >> > >> > > > >Here's the thing: This is a SQL Server error but SQL Server shouldn't be > >involved in a QoQ right? It's all done by the CF server, so as Philip > >pointed out the datasource in your cfquery is causing confusion. > > > > > > >