TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Server
Cold Fusion Server Tech

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Server:
Subject: Re: max variable length

Ricki Stern (6p/+0r) Posted: Tuesday 06 Mar 2001
This post: 41 views, +0 rating

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" <xisle@iol.ie> To: "CF-Server" <cf-server@houseoffusion.com> 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:xisle@iol.ie] > >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 cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Similar Subject Line Posts (+/- two weeks of this post)

RE: max variable length	07 Mar 2001	(40 v/ +0 r)
RE: max variable length	06 Mar 2001	(45 v/ +0 r)
RE: max variable length	06 Mar 2001	(31 v/ +0 r)
RE: max variable length	06 Mar 2001	(35 v/ +0 r)
Re: max variable length	06 Mar 2001 (this post)	(41 v/ +0 r)
RE: max variable length	06 Mar 2001	(42 v/ +0 r)
RE: max variable length	06 Mar 2001	(27 v/ +0 r)
RE: max variable length	06 Mar 2001	(29 v/ +0 r)
RE: max variable length	06 Mar 2001	(45 v/ +0 r)
Re: max variable length	06 Mar 2001	(39 v/ +0 r)
Re: max variable length	06 Mar 2001	(43 v/ +0 r)
RE: max variable length	06 Mar 2001	(30 v/ +0 r)
RE: max variable length	06 Mar 2001	(32 v/ +0 r)
max variable length	06 Mar 2001	(40 v/ +0 r)
max variable length	06 Mar 2001	(27 v/ +0 r)

Send a reply to the CF-Server list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)