Oh God, do I feel stupid. I've seen that setting a million times and I just
didn't think of it. I'm not in work now, but I'm sure that's the problem.
The default is 65000 chars.
Thanks very much
Mark
At 08:58 PM 3/6/01 -0500, you wrote:
>Have you tried adjusting the buffer size for the datasource? Here's a
>description of what it's for:
>Long Text Buffer Size
>Specifies the number of characters to retrieve from a long text field
>if "Enable retrieval of long text" is not set. In this case, ColdFusion
>binds
>text columns to a buffer whose size you specify in this field. If you
>specify
>a size that is not supported by your database, an SQL execution error occurs
>when you try to retrieve the data. Default is 65K.
>
>Deb
>
>> -----Original Message-----
>> From: Mark Woods [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, March 06, 2001 6:22 PM
>> To: CF-Server
>> Subject: RE: max variable length
>>
>>
>> using the merant drivers that come with CF 4.5.2, using LONG datatype 'cos
>> this particular Merant driver was unreliable with CLOBS. Driver
>> update is a
>> possible solution, will see if there is a free update, if not, I want to
>> make sure the problem is the driver before shelling out.
>>
>> I can successfully insert up to 64,999 characters using the Merant ODBC
>> driver, but any more just get truncated (no warning). I know I can work
>> around this with a transaction containing an insert and one or more
>> updates, but I really don't want to. Also, the stored procedure
>> route is to
>> be avoided as this app will almost certainly be moving to postgres later
>> this year.
>>
>> Still puzzled,
>>
>> Mark
>>
>>
>> At 04:15 PM 3/6/01 -0500, you wrote:
>> >Mark,
>> >what driver are you using ? Have you tried Merant driver ..it
>> supports clobs
>> >well. (it comes at a price of course!)
>> >-Vinod
>> >
>> >-----Original Message-----
>> >From: Ricki Stern [mailto:[EMAIL PROTECTED]]
>> >Sent: Tuesday, March 06, 2001 3:57 PM
>> >To: CF-Server
>> >Subject: Re: max variable length
>> >
>> >
>> >If you want to insert something more than 4000 chars you have to bind the
>> >data. I was able to search the web and see how top do it in Perl
>> but I don't
>> >know how to do it in CF
>> >
>> >Ricki Stern
>> >----- Original Message -----
>> >From: "Mark Woods" <[EMAIL PROTECTED]>
>> >To: "CF-Server" <[EMAIL PROTECTED]>
>> >Sent: Tuesday, March 06, 2001 1:34 PM
>> >Subject: RE: max variable length
>> >
>> >
>> >> Oracle SQL statements are restricted to 4000 chars, as are
>> oracle varchar
>> >> datatypes, but I'm using ODBC and LONG datatypes. I've
>> replicated the same
>> >> issue on NT4/IIS4/CF4.0/SQLServer7
>> >>
>> >> Have done some further testing - CF variables are not limited to 64,999
>> >> chars (even form variables). It appears to be an ODBC issue. I
>> know this
>> >> ain't strictly a CF question, but anyone know if there is a
>> limit to the
>> >> size of single value in an ODBC SQL statement?
>> >>
>> >>
>> >> Thanks again
>> >>
>> >> Mark
>> >>
>> >> At 06:21 PM 3/6/2001, you wrote:
>> >> >I'm not certain about a max in CF but I'm relatively sure
>> there is a max
>> >in
>> >> >ORACLE. If I recall it's 4000 characters.
>> >> >
>> >> >Is your textarea returning more than that? That might be it.
>> >> >
>> >> >J.
>> >> >
>> >> >John Wilker
>> >> >Web Applications Consultant
>> >> >Allaire Certified ColdFusion Developer
>> >> >
>> >> >Office: 909-943-8428
>> >> >www.billtracker.org <http://www.billtracker.org>
>> >> >
>> >> >
>> >> >-----Original Message-----
>> >> >From: Mark Woods [mailto:[EMAIL PROTECTED]]
>> >> >Sent: Tuesday, March 06, 2001 10:14 AM
>> >> >To: CF-Server
>> >> >Subject: max variable length
>> >> >
>> >> >
>> >> >anyone know what the maximum length of a CFML variable is?
>> >> >
>> >> >I'm having problems inserting data from a textarea formfield
>> into oracle
>> >> >using the ODBC drivers. Running CF 4.5.2 on apache/redhat. I know
>> >netscape
>> >> >restricts the number of characters that can go into a
>> textarea, but I'm
>> >> >using IE and I have checked the received header when posting
>> from IE and
>> >> >there do not appear to be any restrictions imposed by IE. My
>> next suspect
>> >> >is the max size of a CF variable.
>> >> >
>> >> >
>> >> >Thanks
>> >> >
>> >> >Mark
>> >> >
>> >>
>> >>
>> >
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
