On a previous project, one of the developers wrote a
script to cut up the serialized client variables into
4K chunks, and then put them back together when he
pulled them out of the database. Of course, he had to
forego the use of CF's client variables.
--- Chris Norloff <[EMAIL PROTECTED]> wrote:
> Thanks. Yes, that's pretty much what's happening
> here. I think what we'll do is create a table to
> insert items one at a time, so we don't go over the
> 4000 character limit when the client variables are
> all inserted at once.
>
> thanks,
> Chris Norloff
>
>
> ---------- Original Message
> ----------------------------------
> from: "Mike Townend" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> date: Thu, 13 Sep 2001 17:56:56 +0100
>
> >Depends on what you are doing... I recently had the
> same problem.. I was
> >saving the results of a db search to a wddx packet
> in a client var...
> >Till it got too big.
> >
> >My work around was to save the search params in the
> client var and
> >requery the database to reget the same results
> >
> >
> >
> >-----Original Message-----
> >From: Chris Norloff [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, September 13, 2001 16:41
> >To: CF-Talk
> >Subject: filled up a client var
> >
> >
> >Hi, I've just filled up a client variable - what
> now?
> >
> >Though the "Long" data field in the CDATA table can
> handle up to 2GB,
> >we're getting an Oracle error (no. 1704) that the
> "string literal too
> >long" - apparently there's a 4000-character
> limitation. I've exceeded
> >that with my 6500-character WDDX packet stored in a
> client variable.
> >
> >To use a longer string we need to use bind
> variables in Oracle - the
> >database guys are working on that now.
> >
> >Anybody else deal with this?
> >
> >thanks,
> >Chris Norloff
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
