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
