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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists