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.
Mark
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 7:48 AM
To: CF-Talk
Subject: RE: Limit on SQL passed via CFQuery to SQL Server?
> I'm currently running a query that is 64KB of SQL text - and
> that wasn't a typing mistake!
I wouldn't be surprised at all if the SQL string was treated as a variable
in CF - with a limitation of 64Kb.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
