Re: cfqueryparam error in cfmx 6.01

[Jochem van Dieten]

[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.mrkt_sctr#">)

But here you use a varchar.

What datatype is mrkt_sctr_id?
Are there any empty list elements?

Jochem

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281169
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

cfqueryparam error in cfmx 6.01

[owner]

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 contained
in variables.mrkt_sctr:

and rms.mrkt_sctr_id in (#variables.mrkt_sctr#)

If I do this:

and rms.mrkt_sctr_id in ()

I only get 7 results(debug info says seven and there are only 7 records
listed)...the results that would have been generated by the second
parameter in the list of market sectors is ignored int he results. If a
3rd market sector is added, I see the results of the 1st 2 market sector
id's...but the 3rd is ignored. If I put the query (as output by the CF
debug info) into SQL Navigator and replace the ?'s withthe actual
values...I get the appropriate number of results. IF you look at the
results on the webpage, the results that would have been generated by the
3rd parameter are missing.

There is nothing else in the code that would limit the number of rows
rerturned by the query.

Any Ideas?

Thanks
Eric Roberts
Owner/ColdFusion Developer
Three Ravens Consutling
http://www.threeravensconsulting.com


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281168
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4