Alex, That did it. I had looked at examples that appeared to have spaces before the comma. I removed my space and it work.
Thanx so much, Steve On Fri, Jan 13, 2012 at 3:19 PM, Steve B <[email protected]> wrote: > Yes, I have <string><comma><space><string>. Should I remove the space? > > > > On Fri, Jan 13, 2012 at 3:00 PM, Alex Skinner <[email protected]> wrote: > >> 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 >> > > -- 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
