All I can tell ya is Oracle is limited to 1000 elements in your IN/NOT IN
list.so 2100+ is most liley not allowed ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL
Billy Jamme said:
The problem occurs when I attempt to use cfqueryparam to fetch a
2100+ item list of records.
cfquery name=selectList datasource=database
SELECT id
FROM tempTable
WHERE id IN (cfqueryparam value=#list# list=true
cfsqltype=cf_sql_integer)
/cfquery
To
I realize that the list is a list of integers, but, being a list,
wouldn't the datatype be something akin to a string? How is that handled
within cfqueryparam?
Cutter
Jochem van Dieten wrote:
Billy Jamme said:
The problem occurs when I attempt to use cfqueryparam to fetch a
2100+ item list
I realize that the list is a list of integers, but, being a
list, wouldn't the datatype be something akin to a string?
How is that handled within cfqueryparam?
The CFQUERYPARAM tag tells the database that it's a series of integers, and
that's all that matters. Each integer value is replaced
Dave, thanks for the clarification.
Cutter
Dave Watts wrote:
I realize that the list is a list of integers, but, being a
list, wouldn't the datatype be something akin to a string?
How is that handled within cfqueryparam?
The CFQUERYPARAM tag tells the database that it's a series of
Hello All,
I'm having some DB issues and I'm wondering if I could get some help with it.
I'm running CFMX7, and MSSQL2k. On this specific task, I'm using the IN or NOT
IN clauses in sql to grab a set of records.
The problem occurs when I attempt to use cfqueryparam to fetch a 2100+ item
list
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 1:40 PM
To: CF-Talk
Subject: cfqueryparam BIND list limit
Hello All,
I'm having some DB issues and I'm wondering if I could get some help
with it.
I'm running CFMX7, and MSSQL2k. On this specific task, I'm using the IN
or NOT IN clauses in sql
7 matches
Mail list logo