Re: cfqueryparam BIND list limit

2006-05-24 Thread Bryan Stevenson
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 PROTEC

Re: cfqueryparam BIND list limit

2006-05-23 Thread Cutter (CFRelated)
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 o

RE: cfqueryparam BIND list limit

2006-05-23 Thread Dave Watts
> 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 replace

Re: cfqueryparam BIND list limit

2006-05-23 Thread Cutter (CFRelated)
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

Re: cfqueryparam BIND list limit

2006-05-23 Thread Jochem van Dieten
Billy Jamme said: > > The problem occurs when I attempt to use cfqueryparam to fetch a > 2100+ item list of records. > > > SELECT id > FROM tempTable > WHERE id IN ( cfsqltype="cf_sql_integer">) > > To further troubleshoot I installed the jTBS 1.2 drivers and I ran > all 3 quer

RE: cfqueryparam BIND list limit

2006-05-22 Thread Everett, Al \(NIH/NIGMS\) [C]
Jamme [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

cfqueryparam BIND list limit

2006-05-22 Thread Billy Jamme
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