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
