cfqueryparam error in cfmx 6.01

I get an error in the result set when using cfqueryparam in a SQL IN statement. This is on RHE with CFMX 6.01 and an Oracle 10g DB In this instance, the query should have returned 8 records...as confirmed using SQL Navigator This works fine regardless of the number of prameters inthe list

Re: cfqueryparam error in cfmx 6.01

[EMAIL PROTECTED] wrote: This is on RHE with CFMX 6.01 and an Oracle 10g DB and rms.mrkt_sctr_id in (#variables.mrkt_sctr#) This should not work for a varchar, only for a numeric or date datatype. If I do this: and rms.mrkt_sctr_id in (cfqueryparam cfsqltype=cf_sql_varchar list=yes