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
