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
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: mjohnson [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 16:07
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.
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
