using the merant drivers that come with CF 4.5.2, using LONG datatype 'cos
this particular Merant driver was unreliable with CLOBS. Driver update is a
possible solution, will see if there is a free update, if not, I want to
make sure the problem is the driver before shelling out.
I can successfully insert up to 64,999 characters using the Merant ODBC
driver, but any more just get truncated (no warning). I know I can work
around this with a transaction containing an insert and one or more
updates, but I really don't want to. Also, the stored procedure route is to
be avoided as this app will almost certainly be moving to postgres later
this year.
Still puzzled,
Mark
At 04:15 PM 3/6/01 -0500, you wrote:
>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
