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 ( list="yes" separator="," value="#variables.mr

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 cont