That did it. I guess when the system has been up for a while, I simply forget about the admin functions. Thanks a million.
John -----Original Message----- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 10:38 AM To: CF-Talk Subject: RE: CFQUERY NOT RETURNING COMPLETE RESULT While I've not encountered that problem myself, I believe you'll want to go into the CF Admin under the ODBC settings and enable the "Long Text Retrieval Settings" and adjust the "Long Text Buffer Size" as appropriate. Ken -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 10:26 AM To: CF-Talk Subject: CFQUERY NOT RETURNING COMPLETE RESULT OK, Folks, please be patient with me. This may be somewhat off topic, but where else can I go? I'm using a simple <CFQUERY> to insert a large text block into a MSSQL 7.0 column with a data type of TEXT. I then use a simple SELECT query to retreive the result. Only the first 65K Bytes are being returned. Since Query Annalyzer only displays a limited result, I can't really tell if the whole text block is being inserted. Is there a problem with the data being too large? Is there a workaround without having to be an expert SQL programmer? John Grubb ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists