It seems to me that there is a database setting (long text buffer size) that
only allows 65,000 characters by default...
In CF 4.5+ you can adjust this setting...do a character count of your
insert in the database and I'll bet it is 65,000 characters.
Let me know (if anyone knows) what this option is for if I am incorrect.
- BILL -
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 8:25 AM
To: CF-Talk
Subject: Limit on SQL passed via CFQuery to SQL Server?
Does anyone know if there is a limit to the amount of text that is passed in
a CFQuery to SQL Server?
I'm currently running a query that is 64KB of SQL text - and that wasn't a
typing mistake!
The problem is that when it seems to break a certain size and return zero
records or the query won't exist
It's a real problem as it's part of a reporting system I'm trying to build
for a client
The theory is that they can get some data, then they trim the data down a
bit, and again, and again
What usually happens though is that want the whole lot of data (13,000+
records, 40+ fields is one example) and because of the way I do the queries
it's too big - I'm using the Identitys and then running WHERE on the results
(if you know what I mean)
Running on CF4.5.1 SP2, SQL Server 7 SP3, NT Server 4 SP6a (separate
machines for CF and SQL)
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
