Re: Oracle IN limit

2005-10-27 Thread Troy Simpson
1000 -- Thanks, Troy ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:22

Re: Oracle IN limit

2005-10-27 Thread Bryan Stevenson
> If you have a subquery within the IN, no, there is no limit. Are you sure about that?? 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 PROTECTED] web: www.electricedgesystem

Re: Oracle IN limit

2005-10-27 Thread Deanna Schneider
Yes, yes there is. On 10/27/05, Robert Everland III <[EMAIL PROTECTED]> wrote: > > Does anyone know if there is a limit to how many items I can put in an IN > clause? > > > > Bob > > ~| Discover CFTicket - The leading ColdFusion

Re: Oracle IN limit

2005-10-27 Thread Bryan Stevenson
1000 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 PROTECTED] web: www.electricedgesystems.com ~| Logware

Re: Oracle IN limit

2005-10-27 Thread Dave Carabetta
On 10/27/05, Robert Everland III <[EMAIL PROTECTED]> wrote: > Does anyone know if there is a limit to how many items I can put in an IN > clause? > 1000. Regards, Dave. ~| Find out how CFTicket can increase your company's custo

Re: Oracle IN limit

2005-10-27 Thread Aaron Rouse
There is a limit to it, but offhand I do not know what it is. On 10/27/05, Robert Everland III <[EMAIL PROTECTED]> wrote: > > Does anyone know if there is a limit to how many items I can put in an IN > clause? > > > > Bob > > ~|

RE: Oracle IN limit

2005-10-27 Thread Mike Klostermeyer
If you have a subquery within the IN, no, there is no limit. If you specify individual items (1,2,4,2, etc.), I have reached a limit with SQL Server, but I don't recall what it was (well into the 5 figures). A subquery is the best solution. Mike -Original Message- From: Robert Everland