Our DBA (very smart guy) frowned on our use of the "IN" clause....perhaps
you may consider taking a relational approach to this query. The entire
thing could be done inside a stored procedure (eliminating your current
problem) and without the use of the "IN" clause.
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 11:47 AM
Subject: RE: Limit on SQL passed via CFQuery to SQL Server?
> > If I were you I'd put it in an SP. I know there used to be a limit to
the
> > length of an SP in 6.5 but as far as I'm aware this issue was
> > addressed in 7
>
> My problem is that the majority of the data is the list of Identities used
> in the IN()
>
> I'm not sure how if a SP can handle this better than a CFQuery
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
