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

Reply via email to