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
