i'm not an oracle guy, but your problem sounds similar to this so see if it
helps in any way:
in SQL server, if you use a stored procedure to insert into a varchar column
(for example) and do not specify the length of the varchar column (which you
set or it defaulted when you created the table) in the stored procedure,
the data insert will truncate.
----- Original Message -----
From: "Rose, Israel" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 11:38 AM
Subject: How to Store Comments or Large Text Messages?
> Along with other data, I'm incrementally inputting large text messages as
> comments, saving them to a temporary file in an Oracle database, and
> querying that file for final storage to a permanent record file in the
same
> database. At the last step in this process, I somehow lose all except the
> first word of these messages. I know (according to Ben Forta Cold Fusion
> 4.0, Note on Page 154) that ODBC drivers have a problem processing the
> double quote (") mark seeing it as a statement terminator. But, since the
> data is being stored in a temporary location (I can see the results of the
> query from this location), I don't see how this could be even remotely
> related. I am lost and/or way off base as to a solution. Could this be a
> Cold Fusion problem or is this an Oracle problem?
>
> Israel Rose
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
