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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
