No problem A
On 13 January 2012 23:26, Steve B <[email protected]> wrote: > 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 > -- 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
