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
> 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
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
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
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
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
>
>
~|
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
7 matches
Mail list logo