FYI, if you have a dirty list that you need to clean up from spaces, you
can use ListItemTrim():
http://www.openbd.org/manual/?/function/listitemtrim
It's like Trim() for lists. It removes whitespace at the beginning and
end of each item in the list.
.pjf
Alex Skinner said the following on 01/13/2012 05:29 PM:
No problem
A
On 13 January 2012 23:26, Steve B <[email protected]
<mailto:[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]
<mailto:[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] <mailto:[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]
<mailto:[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 <tel:%2B448452600726>
Email: [email protected] <mailto:[email protected]>
Web: pixl8.co.uk <http://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] <mailto:[email protected]>
Web: pixl8.co.uk <http://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
--
Peter J. Farrell
[email protected]
[email protected]
http://blog.maestropublishing.com
Identi.ca / Twitter: @maestrofjp
--
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
