I seem to remember that there's a max length to a query that can be sent
using cfquery. we're using cf 4.5 and ms sql. Specifically, we're having a
discussion about whether or not to save a list of id's and then have a VERY
large "not in ()" outputting the saved list of id's using cf, or instead
putting a query in the "not in" and letting sql server handle it. There are
some specifics to this task which makes the list of id's much easier, but I
think if the number of id's gets too large, that we will hit the max
allowable length of a query, so I was wondering if anyone knew offhand what
that limit would be, or if it's specific to our setup and settings, how that
limit could be determined, so we can choose the better path.
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
