Yes, your errors are related. There are knowledge base articles on
Allaire's site on how to work with strings longer than 4k. They won't help
you with client variables unless Allaire rewrites that piece of code to use
the workarounds.
Dan
-----Original Message-----
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 10:23 AM
To: CF-Talk
Subject: RE: client variables, WDDX, and Oracle
Curious, I am.
Is the error that you're getting:
Oracle Error Code = 1704
ORA-01704: string literal too long
I ask because I'm working with Spectra on an Oracle db and that error is
beginning to be a big bug in my hide. I'd like to know if your problems and
mine might be related.
> -----Original Message-----
> From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 20, 2000 12:37 PM
> To: CF-Talk
> Subject: RE: client variables, WDDX, and Oracle
>
>
> Surely you don't have to store that much info on each item?
>
> -----Original Message-----
> From: Scott Weikert [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 20, 2000 5:21 PM
> To: CF-Talk
> Subject: client variables, WDDX, and Oracle
>
>
> Hey gang -
>
> Got a quandary here. We're working on a order placement
> system. The plan is
> to keep a running status of the order in a client variable,
> stored in WDDX.
> Top of each page, deserialize the packet, add/adjust the
> contents of the
> resulting structure based on the previous form's content,
> reserialize into
> the client variable.
>
> We're running Oracle - and apparently Oracle has a 4k
> character limit on
> fields. So getting just a few items into this
> structure/packet (lots of info
> per item) is making us hit this upper character limit, and
> the thing bombs.
>
> Suggestions? Any way to get around that limit on Oracle? A
> couple of ideas
> we've batted around are using an application variable to
> store this stuff
> temporarily and nuking it once the order is placed, or using
> the file system
> to read/write to a file instead of a client variable.
>
> --Scott
>
>
> **********************************************************************
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received
> it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **********************************************************************
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists