Try something like this Do you mean to have the space in front of H013 ? A
On 13 January 2012 22:54, Steve Of LA <[email protected]> wrote: > 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 > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- 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
