What yo might want to do is a join instead of an IN(). I don't know what
you are matching in your in statement, but here is an idea. Create a
temporary table and insert all the values that would be in your IN()
statement. Then do an inner join to the temporary table.
Example:
CREATE TABLE #sometemp (inkey int)
<!--- might need to be a loop here --->
INSERT INTO #sometemp
(inkey)
VALUES
(value)
<!--- end of loop --->
SELECT x,y,z FROM sometable INNER JOIN #sometemp ON sometable.x =
#sometemp.inkey
Wahlah you have the same results.
Mark
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 9:47 AM
To: CF-Talk
Subject: RE: Limit on SQL passed via CFQuery to SQL Server?
> yes this is true. I have experienced it doing multiple inserts
> withing one
> CFQUERY statement. The worst part of it is that it doesn't return
> any errors
> it just chops off the end of the query. So in my case some records were
> missing from the db. My solution was to keep track of how much text was
> being put into the CFQUERY tag and then creating a new CFQUERY on the fly.
I do multiple inserts a lot... it's just this one query that's causing me
problems...
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
