Comparison Exception: While executing "="

[nohandlesleft254]

Hi,

Can anyone see whats wrong with the query or queries below, i keep getting the error - 'Query Of Queries runtime error.
Comparison Exception: While executing "=" ' but i can see a thing wrong...

<cfquery name="CheckForUnits" dbtype="query">
SELECT
SerNr,
PlanRef,
Code,
Name,
Quant,
Hand,
Height,
Width,
Depth,
TotalPrice,
RowTotalPrice,
UnitText,
IntDepth,
ItemClass,
SpecDRang,
ItGroup,
ConfirmOK
FROM RecordRows
WHERE ItGroup = <cfqueryparam cfsqltype="cf_sql_char" value="UNIT">
AND PlanRef IN (<cfqueryparam list="yes" separator="," value="#preserveSingleQuotes(form.PlanRef)#">)
ORDER BY PlanRef ASC
</cfquery>

 

[r937]

as far as i recall, QofQ can't use CFQUERYPARAM

perhaps i'm wrong, but looking at your QofQ, why use CFQUERYPARAM at all? it's not like you can get SQL injection here

try just coding the values



r937.com | rudy.ca

 

[nohandlesleft254]

Ive tried both ways and it always throws the '=' - i have also been using queryparam on some other QofQ's as otherwise i get:

Comparison Exception: While executing "="
Unsupported Type Comparison Exception: Comparator operator "=" does not support comparison between following types:
Left hand side expression type = "DOUBLE".
Right hand side expression type = "STRING".

(and with the queryparam it works)

it doesnt make any sense.....

 

[r937]

okay, that last part is very pertinent

what are the datatypes of ItGroup and PlanRef?

r937.com | rudy.ca

 

[nohandlesleft254]

the query is created using QueryNew and QuerySetCell etc - so i dont think the fields have a datatype as such?...

 

[r937]

well, CF seems to think that either ItGroup or PlanRef is DOUBLE, i.e. numeric

r937.com | rudy.ca

 

[nohandlesleft254]

OK thanks - that helps anyway - i couldnt find what double meant.. ill have a dig and see what ive done wrong.