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

Reply via email to