Hello, I am migrating a site from CF2016 to Lucee 5, and I have a query of
queries that works under CF but throws the error ‘Not a condition’ under
Lucee. The query in question:
<cfquery name="SortedProducts" dbtype="query">
SELECT sum(units) AS units, description, type
FROM MyQuery
WHERE (type = 'V' OR type = 'M')
GROUP BY description, type, units
ORDER BY type DESC, description
</cfquery>
The query MyQuery has the following structure, and is filled by a series of
cfloops and querySetCell():
<cfset myQuery=QueryNew( “patient_id, patient_name, type, dos_start,
description, payment, units, unitprice, charge, covered, notcovered, copay,
coinsurance, deductible, claim_amt, insurance_paid, patient_resp, id,
remit_date, status, billto, transaction_dt”, “Integer, VarChar, VarChar,
Date, VarChar, Decimal, Decimal, Decimal, Decimal, Decimal, Decimal,
Decimal, Decimal, Decimal, Decimal, Decimal, Decimal, Integer, Date,
VarChar, VarChar, Date” )>
Apologies if I missed a previous answer in my search.