[OpenBD] cfqueryparam not creating list?

[Steve Of LA]

Is there a way to see the parameters that are injected into the SQL
query?
I'm trying a pass a character string list to a CFC and have that list
be in used in an SQL IN clause.

Here is the cut down code:

<cfset REQUEST.ClassCodeList = "H012, H013">

cfquery name="qAcctNbr" datasource="#REQUEST.DataSourceName#" >
        SELECT
            A.ACCOUNT_NUMBER, A.REVENUE_TYPE AS FUND_CLASS_CODE,
            A.EFFECTIVE_DT, A.END_DT
        FROM
            ACCT_TP A
        WHERE
            A.REVENUE_TYPE in (<cfqueryparam
value="#ARGUMENTS.ClassCodeList#" cfsqltype="CF_SQL_VARCHAR"
list="true"> )
                        AND A.ACCOUNT_NUMBER LIKE <cfqueryparam 
value="#ARGUMENTS.acctNbr#
%" cfsqltype="CF_SQL_VARCHAR" maxlength="24">
        </cfquery>

When I execute the code and dump, it is retrieving the row that's
associated with the H012 parameter, but not the H013.  Any thoughts?

I'm running OPENBD 1.3 and Oracle.  (Yes, I know that's old.)

Steve



-- 
online documentation: http://openbd.org/manual/
   google+ hints/tips: https://plus.google.com/115990347459711259462
     http://groups.google.com/group/openbd?hl=en

     Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012