mine! Good call!
John
-----Original Message-----
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 4:20 PM
To: CF-Talk
Subject: RE: String Length Hard-Limit (NOT a RegEx question)
Just go to administrator page of cf server and increase the buffer size
to whatever you want. It is 64999 by default.
TK
-----Original Message-----
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 4:14 PM
To: CF-Talk
Subject: RE: String Length Hard-Limit (NOT a RegEx question)
Now that you know the amount, in theory, you could insert the first
64999 characters and then do an update on that row to append the rest
of
the chars to the initial value in the DB. It's like duct tape, it
might
not be pretty but it should work. (maybe) :-)
John
-----Original Message-----
From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 4:11 PM
To: CF-Talk
Subject: Re: String Length Hard-Limit (NOT a RegEx question)
Well I did some testing and CF handled gigantor strings (20 million
characters and more) without fail, even via form posts. but the sql
insert truncated all inserted strings down to 64999 characters.
I wonder if I could insert larger values using a stored procedure and
query params?
MS SQL documentation says that ntext columns can hold about a billion
unicode characters a pop-- i just dont know how to pop them in there
i didn't realize there were other limitations in the sql call itself.
but at least i know the exact upperbound for vanilla sql now. i'll
just
throw on some client-side form validation to keep users from going
over
the 64999 character limit until i do some more reading on the
subject...
thanks for your help everybody! cf-talk is the best.
--brendan
>Ah, after Dave said 65k, made me think, isn't the datasource long
text
>buffer size 65000 bytes by default? Could this be your issue?
>
>-----Original Message-----
>From: Craig Dudley
>Sent: 07 April 2004 17:02
>To: CF-Talk
>Subject: RE: String Length Hard-Limit (NOT a RegEx question)
>
>
>I suppose another possible culprit would be the datasource, have you
>enabled clobs? just a thought.
>
>-----Original Message-----
>From: Brendan Baldwin [mailto:[EMAIL PROTECTED]
>Sent: 07 April 2004 16:57
>To: CF-Talk
>Subject: String Length Hard-Limit (NOT a RegEx question)
>
>Does CF have a hard-limit on number of characters for string
variables?
>Do form posts from textareas themselves have a hard-limit? We have a
>database column of type nText which is truncating well before the
>(2^30)-1 character limit and I suspect an internal CF limit may be
the
>culprit.
>
>Thanks!
>
>Brendan
> _____
> _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
