If it goes 4000 chars, you will need to save it as blob in oracle.
The oracle driver supports blob datatype.
-----Original Message-----
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 1:22 PM
To: CF-Server
Subject: RE: max variable length
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