Unfortunately it is often very difficult to build a very dynamic query using
a SP. Imagine I want to build the entire syntax of a query via cf. Lets say
I want to create 15 insert statements that all insert different values. I
build a cfloop and start generating the SQL statement sticking it into one
string. In order to save on the ODBC connection time I place them all
within one CFQUERY tag. This works great and is much faster than looping
over the CFQUERY tag until you hit the 64k limit.
You can't get a SP to simulate this type of behavior.
Mark
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 8:12 AM
To: CF-Talk
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
------------------------------------------------------------------
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
