I know that some syntax is not valid when querying a query and at first
glance, the "IS NOT NULL" might be the culprit. I'm not 100% sure on
that though.
Mark
-----Original Message-----
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 9:11 AM
To: CF-Talk
Subject: problems querying a query
I am trying to query the results of a query against
SQL server and am getting errors. The first query I
am running is:
<cfquery name="qGetFour" datasource="DEU">
SELECT CertificateID, AuditDate, WasVetTopOfCert
FROM dbo.tblDEUCertificates
WHERE AuditDate IS NOT NULL
</cfquery>
The second query is:
<cfquery name="qGetFive" dbtype="query">
SELECT WasVetTopOfCert
FROM qGetFour
WHERE WasVetTopOfCert IS NOT NULL
</cfquery>
The error I get is:
Error Diagnostic Information
Query Manipulation Error Code = 0
Invalid Operator WasVetTopOfCert
SQL = "SELECT WasVetTopOfCert FROM qGetFour WHERE
WasVetTopOfCert IS NOT NULL"
Data Source = ""
Query qgetFour runs ok. WasVetTopOfCert is a bit
field set to accept nulls. I have a feeling the
problem is in the I check the a bit field for null
values. Any ideas?
Tim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
